To follow an index you'll need an order by clause for the indexed column. (http://db.apache.org/ojb/api/org/apache/ojb/broker/query/Criteria.html#addOrderBy(java.lang.String,%20boolean))
If you do not use an order by clause the RDBMS is not forced to serve rows in a certain sequence.
cu, Thomas
A Leg wrote:
Hi
When we use *getIteratorByQuery and .next(). * do we move throw the table following the index or in some random order ?
If we go in random order, what is the best way (getting advantage of the cache) to iterate in a table following the index ?
Thank's
Andre
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
