Re: tkprof show many fetches with high elapsed time

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 7 Jan 2007 11:45:31 -0000
Message-ID: <YO-dnUVIpeJFQD3YRVnyhgA@bt.com>

"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

Received on Sun Jan 07 2007 - 05:45:31 CST