This discussion is archived
13 Replies Latest reply: Sep 25, 2012 5:48 AM by 698658 RSS

Cardinality linear decay in 9.2.0.8

698658 Newbie
Currently Being Moderated
Hi,
lets say I've got date column with increasing date (populated as sysdate) , in point of time I created index (compute statistics) on that column without histogram (only min/max value) .
So if I dont regather stats on that column, my cardinality estimate will go lower day after day till value of 1 , right (because out of linear decay) ?
Regards
GregG

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points