General discussion


Implement search paging queries

By MaryWeilage Editor ·
This week's Oracle e-newsletter explains how to implement search paging queries.

Does this tip offer you clear instructions on how to implement search paging queries? What topics would you like to see us cover in future editions of this e-newsletter? Please let us know.

If you aren't subscribed to the free Oracle e-newsletter, click the following link to automatically sign up:

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Major Paging Caveat

by dolthead In reply to Implement search paging q ...

That last line of the "Search Paging" article is critical. We have never been able to use the rownum filter in our queries, since we rely heavily on the rule-based optimizer. Our only recourse has been to use the Java JDBC feature, stmt.setMaxRows(p_max), where stmt is a Statement object and p_max is number of rows you want returned.

Collapse -

no rownum? migrate to cost-based?

by swstephe In reply to Major Paging Caveat

rule-based optimization is going away and only cost-based, (automatically maintained), will replace it.

Yes, you will need to shoe-horn your queries to use the rownum filter ... but I'm not sure why you can't have both. You can build your queries in views, then use the rownum coming back from the view's query, (rownum is applied only after data is returned, so optimization shouldn't matter).

Collapse -


by er3r In reply to no rownum? migrate to cos ...
Collapse -

Looking for this tip

by scrigno In reply to Implement search paging q ...

Hi all,
I'm new on techrepublic.
Do you know where can I find the body of above week's Oracle e-newsletter?

Related Discussions

Related Forums