Re: Using prefetch with cursors (performance)

In that case do we know of anything that would increase performance when reading from a cursor.
The only thing this read loop would do is read from cursor, manipulate data and write to a text file.
Can we make use of hints here? Note that we need the data sorted as per subscriber id which does have an index and we have already used ORDER BY clause. Received on Mon Jun 09 2003 - 05:39:08 CDT