i have index some col's using the phpmyadmin
and in the table with the list of the index col's 1 of the col's name is
"Cardinality" - what does this mean?
and what dooes it mean that Cardinality is null?
thnaks in advance
peleg
index's of cols col's
Moderator: General Moderators
Cardinality the number of discrete items in the table. High Cardinality means that there are few items(like gender, or a boolean field) and the index will be less useful, as its has far more matches to sort thru. Indeces on this type of data will likely not get used as it would return up to 50% of the rows. Low Cardinality is the opposite, having lots of discrete values and makes matching easier using the index, (like autonumbers, SSNs)
Null, I think would indicate that there are no repeated values
Null, I think would indicate that there are no repeated values