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: Cost Base Optimizer on 3 table select

Re: Cost Base Optimizer on 3 table select

From: Ross Mohan <nonspam_rmohan_at_ix.netcom.com>
Date: Fri, 23 Oct 1998 12:55:32 -0400
Message-ID: <70qbt8$i3c@dfw-ixnews8.ix.netcom.com> 





<snip>.....




there are times when


>using hints is the most efficient way to ensure a consistent execution


plan.



HINTs do *not* always result in changed query plans.  You must check these
query paths just like any others.



There is a reason they are called "HINTs" and not "COMMANDs".  ;->



Ross Mohan


Received on Fri Oct 23 1998 - 11:55:32 CDT












Original text of this message













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