Collect stats behaving oddly


Collect stats behaving oddly

In researching a performance problem I spotted some stats on a table which seemed strange.

A column with a cardinality of ~43,000,000 showed correct stats. Another set which _included_ that column showed a value of 1.

I dropped the errant stats and collected some new ones, including that column. A helps stats showed the cardinality as 1 again. I recollected with sample and it changed from 1 to 50.

What Am I doing wrong.

V2 r6.2.2