Re: any ideas for better performance of this query ?

From: <sweidanz_at_yahoo.com>
Date: Fri, 12 Oct 2001 10:03:21 +1000
Message-ID: <Zryx7.10$cH1.347@nsw.nnrp.telstra.net>

Can you please explain how you read it that way and how you knew its cost-based method? If the optimiser is CHOOSE it does not mean Oracle is going use the cost-based!! If none of the tables in the query is analyzed, oracle is going use the rule-based. right?

???????????????????????????????????????????????????????????????????????????????????

I don't read it that way.

from the original post
"

Execution Plan

---

   0 SELECT STATEMENT Optimizer=CHOOSE
"

This says COST based to me. Of course the stats on the tables may well be out of date or inaccurate.

???????????????????????????????????????????????????????????????????????????????

Received on Thu Oct 11 2001 - 19:03:21 CDT