Re: Cost-Based Optimizer

jdennis_at_netcom.com (John Dennis) writes:

>
>I have a nasty query that worked fine on Oracle 6 (just made the switch)
>but is choking on Oracle 7. I "EXPLAINED" the query and it shows

on the hpux port, we uses alter session set sqltrace true to dump the execution path of a large stored procedure. it was consistantly picking the wrong index for the query ( a simple one by the way ). the default optimizer_mode value was in effect. for v7, that is COST. alter your init<FOO>.ora and add the line

optimizer_mode=RULE

after this i think you'll find the hints work. did for us.

praise elvis.
barry

--
   4 players            | barry hannigan             | 
   inferno              |  1960-10303 jasper ave     | death to videodrome
   nightmare            |  edmonton, alberta         | long live the new flesh
   deathmatch on net 666|  t5a 4k5                   |