Re: Why CBO doesn't choose the low cost plan
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <eagle.f@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Jul 2006 21:49:33 +0200
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@xxxxxxxxxxxxx
Sent: Wednesday, July 19, 2006 10:14 AM
Subject: Why CBO doesn't choose the low cost plan
Other related posts:
