Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to tune up this query? (Long post with example)
"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
news:X7d_9.6451$V6.8484_at_news.indigo.ie...
> Which was my point previous on the thread,,, that Susan had to use the
outer
> select for the rownum pull ... this was covered in depth on one of the
> boards last year....
>
> She was right. Improvement I can possibly see is analytic but as I said a
> FTS is on the cards . I'll have a look.
Certainly analytics if available are worth a try (if you can remember where to put all the brackets :(). Sorry if I was repeating you.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Thu Jan 30 2003 - 11:31:31 CST