Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: star transformation not chosen because of bind variables
> I can't wait to see the answer because from my experience hints are
> often ignored.
Yes, hints are definitely ignored when they can't be fulfilled. The simplest case would be to ignore an "index" hint when index plainly doesn't exist on required column. A hint involves a complex set of rules, which are first evaluated before any behaviour will be changed. Star transformation has several documented restrictions, which disable it's use, regardless of any hint or parameter setting.
Btw, there's a parameter _always_star_transformation which could be used in some cases when CBO doesn't want to use ST even though all required conditions have been fulfilled.
Tanel. Received on Sun Sep 28 2003 - 12:34:21 CDT
![]() |
![]() |