Re: Cursor gets slower and slower

Chris Notz wrote: > > Hi > > We have a cursor with about 600'000 records. And it seems, that the > cursor moves slower and slower through the records. At the beginning, it > is very fast. At about 10% (at record #60'000) it is 10 to 20 times > slower! > > Is it true, the more records are in a cursor the slower is the progress > of the records later in the cursor? It should not be, no. However, the nature of the query, its filters, the data distribution, and physical locality CAN affect how fast the engine is able to return rows during an indexes search. During a sequential scan the data rate is normally steady as it is after the wait for sorting in an ORDERED query that requires a physical sort. Art S. Kagel