fareeda_at_pspl.co.in said...
> 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.
>
What you describe is exactly what almost every application I've ever
written from the 1960s to today does: input, process, output.
You need to supply a bit more information. I could answer your question
with something flippant like: if you want better performance, read less
data. That would answer the info you supplied, but I really doubt that's
what you were looking for.
--
/Karsten
DBA > retired > DBA
Received on Mon Jun 09 2003 - 11:30:40 CDT
