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 -> plan_table?

plan_table?

From: Ina Schmitz <web_at_inalein.net>
Date: Mon, 27 Feb 2006 15:15:03 +0100
Message-ID: <dtv1h9$psa$02$1@news.t-online.com> 





Hi NG,



generating the estimated execution plan of my queries, I use "explain plan 
for"


and then select the information I am interested in from the plan_table.
For the optimizer column of the plan_table, I get "ANALYZED" quite often. In 
the


documentation, I just found that there are 4 optimizer modes, RULE, 
ALL_ROWS,



FIRST_ROW and CHOOSE. What is then meant by "ANALYZED" there?



Thanks for help!


Ina
Received on Mon Feb 27 2006 - 08:15:03 CST












Original text of this message













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