Re: pagination of oracle

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 27 Mar 2006 08:08:58 -0800
Message-ID: <1143475738.331627.150240@v46g2000cwv.googlegroups.com>

If the sort algorithm employed by Oracle finds the low value rows first as it makes passes through the data then Oracle can start passing data back to the outer query before all the data has been sorted where the stopkey operation will in fact cause the query to terminate before all the inner query data is fully sorted.

How many rows are sorted will depend on the row size, sort buffering, and sort algorithm in use. Oracle may change any of these between releases.

HTH -- Mark D Powell -- Received on Mon Mar 27 2006 - 10:08:58 CST