Re: Why CBO doesn't choose the low cost plan

Hi E.F.,  

> We have a query choose a bad plan.

> select /*+ index(e) */
 

my experience is, if you use a hint INDEX you should also specify which index should be used. The result of saying only "use some index" could be surprising (see the thread "Does Oracle have a Sense of Humour" in this list for an example).

In your particular case, Jared is probably right, it is a bug.  

Regards,  

Jaromir

• Original Message ----- From: eagle fan To: oracle-l_at_freelists.org Sent: Wednesday, July 19, 2006 10:14 AM Subject: Why CBO doesn't choose the low cost plan

--
http://www.freelists.org/webpage/oracle-l