Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: force cost-based?

Re: force cost-based?

From: George Meltser <meltser_at_aigfpc.com>
Date: Fri, 28 Aug 1998 10:25:14 -0400
Message-ID: <6s6ehg$dm5$1@as4100c.javanet.com> 





you can use /*+ ALL_ROWS */ or /*+ FIRST_ROWS */
for example



Jeff Schramm wrote in message ...


>Is there a hint that can be placed in a query to force Oracle 7.3.3 to


>use the cost-based optimizer when the instance was started with


>opimizer_mode=rule?




Received on Fri Aug 28 1998 - 09:25:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US