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: Why does optimizer determine wrong cardinality when using MOD function? test included

Re: Why does optimizer determine wrong cardinality when using MOD function? test included

From: peter <p_msantos_at_yahoo.com>
Date: 16 Nov 2005 13:55:07 -0800
Message-ID: <1132178107.779334.152750@g44g2000cwa.googlegroups.com> 





I believe in  10g the default is 'FOR ALL COLUMNS SIZE AUTO'.
In 10g, I believe oracle checks the sys.col_usage$ to see how a column
has been used to determine the proper # of buckets when "AUTO" option
is used for method_opt.



I tried my little example with 'FOR ALL COLUMNS SIZE 200' and it still
incorrectly estimates the


number of rows returned.



thanks for the feedback though!


--peter
Received on Wed Nov 16 2005 - 15:55:07 CST












Original text of this message













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