Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using prefetch with cursors (performance)
You have given us such poor information that you are beyond help. If you
try to answer your own question you will see that you have included almost
no information to help you. try again.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "fareeda" <fareeda_at_pspl.co.in> wrote in message news:c6d78d84.0306090239.52b6763_at_posting.google.com...Received on Mon Jun 09 2003 - 08:34:58 CDT
> 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.