What exactly does cardinality mean? Is it the number of unique values in an index? I know it's updated/calculated with 'ANALYZE'. Looking at my indices I see:
id1 146135
id2 3
id3 43
id4 292270
id5 1
id6 3
How does cardinality affect performance - i.e., if it's grossly out-of-date?
