Re: tkprof show many fetches with high elapsed time

Jonathan Lewis wrote:
>
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> news:Xns98B06BA0C27CFanacedenthotmailcom_at_69.28.173.184...
>
> >
> > SELECT s.ID AS ID, s.DATA as DATA
> > FROM PROFILESTOREDATA s,
> > WHERE s.ID IN
> > (select STORE_ID from PROFILESTOREDATA_BATCH b where b.BATCH_ID= :1)
> >
> > Never have in the FROM clause a table which does not contribute to the
> > SELECT clause.
>
> That's an interesting suggestion - but seems a bit
> extreme. What's the rationale behind it ?
>
> --
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html

It suggests that something like:

select count(1)

which has no references to tables should therefore have nothing in the FROM clause

:-)

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------