Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to tune up this query? (Long post with example)

Re: how to tune up this query? (Long post with example)

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 30 Jan 2003 17:31:31 -0000
Message-ID: <3e396173$0$247$ed9e5944@reading.news.pipex.net>


"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 UK
Received on Thu Jan 30 2003 - 11:31:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US