Re: Query Performance

Might help to post the query , the explain plan and the tkprof results. Also the version of the software, what platform, etc. Does the outer query have an order by? That might do it. Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"agonusj" <member_at_dbforums.com> wrote in message
news:2341860.1041550292_at_dbforums.com...


>

> Hi,

>

> I encountered a strange problem when i was trying to enhance a query!

> I've a query which selects simply all the records that were selected

> with in  a subquery.

> When i run the subquery alone it completes in a few seconds but when i

> include a select clause above it to choose the records retrieved by the

> sub query then it takes around six minutes. while i don't use any

> functions or manipulations in the outer select clause and neither i have

> any where clause associated.

> Can some one tell me why this happens and help me with a work

> around for this?

> Thanks in advance for your help.

>

> Cheers,

> Jaipaul.

>

> --

> Posted via http://dbforums.com