Re: Query tuning

From: Bruno D. <bd_avirer__at_arte-tv.com>
Date: Thu, 24 Oct 2002 10:04:30 +0200
Message-ID: <3db7a97a$0$7111$4d4eb98e@read.news.fr.uu.net>

"Billy Verreynne" <vslabs_at_onwe.co.za> a écrit dans le message de news: ap5s90$s30$1_at_ctb-nnrp2.saix.net...
> A work around can be to do away with the sub-select all together and make
it
> part of the join.

Ok. The problem is that the query will generate more rows with a join and a distinct will be necessary.

> Other obvious question is if the relevant tables and indexes are
analayzed?

Yes. But you're right: sometimes it can help.

Finally I solve the problem: I force the CBO to make 'nested loop' rather than 'access full'...

Thanks to all. Received on Thu Oct 24 2002 - 03:04:30 CDT