At 03:20 AM 6/29/2006, Laimutis Nedzinskas wrote:
I can illustrate my point using one example (which seems to be one the the biggest CBO issues actually, discussed many times before):
I have a "select where type='OPENED' "
No need to say that type='OPENED' is 0.1% of all records, the rest are 'CLOSED'.
I built a histogram. Value 'OPENED' happened not to be there because... the were no records with type='OPENED' at the time. Plan was full scan of course.
Regards