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

Home -> Community -> Usenet -> c.d.o.server -> Re: query plan, outln, statistics, off topic

Re: query plan, outln, statistics, off topic

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Sun, 15 Apr 2007 21:31:55 GMT
Message-ID: <pan.2007.04.15.21.31.55@verizon.net> 





On Sun, 15 Apr 2007 13:19:07 -0700, renu_p_r wrote:



> 1) For plan stability : Meaning I do not want too many surprises with

> query plan explain plan : for that one solution is use outline. However

> I think that might add overhead. Does anyone have any other input issues

> with outline.




The best thing for plan stability is not to gather any statistics, once
you've gathered it.


-- 
http://www.mladen-gogala.com


Received on Sun Apr 15 2007 - 16:31:55 CDT












Original text of this message













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