Re: star transformation not chosen because of bind variables

<snipped>

>Hints are only obeyed if they are legal, correct,
>and used in the correct context.
>
>The major pain in the backside with Oracle is
>finding the bit in the documentation where you
>get told what is legal - I checked the SQL Reference
>and the Performance Guide (where it mentioned that
>you can't use star_transformation with cursor_sharing)
>before I got to the Datawarehouse Guide. It's always
>a good source of clues for optimizer issues.
>
>
>

One of my biggest complaints, and something I emphasize to my students, is that Oracle does not
validate hints and report syntax errors: Which I consider as dumb as pounding dirt.

That the following isn't caught:

SELECT /*+ David Bowie */ dummy
FROM dual;

is patently ridiculous (though Richard might disagree). This is something Oracle should have fixed long ago. And yes I have on rare occassion used this feature to comment a select statement but it hardly a valid
justification for making it possible to send garbage to the SQL engine.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)