Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CBO choses wrong path - why???
"Vsevolod Afanassiev" <vafanassiev_at_yahoo.com> wrote in message
news:1112921821.121560.214430_at_z14g2000cwz.googlegroups.com...
> I have a strange case of CBO chosing path that does not make any sense.
> In the simplified form the query is
>
> select * from TabA where col1 = :b1 order by ID;
>
One possiblity is that the EXPLAIN_PLAN cannot detect or identify casting
problems. Is the bind variable of the correct type when it's input? CHAR,
VARCHAR2 etc.
Shabs.
Received on Fri Apr 08 2005 - 04:00:14 CDT