13 Replies Latest reply: Sep 25, 2012 7:48 AM by 698658 RSS

    Cardinality linear decay in 9.2.0.8

    698658
      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