Why does the cardinality of an index in MySQL remain unchanged when I add a new index?

If you only have 1 row in the table, the cardinality for the index should be 1, of course. It's just counting the number of unique values.

I cannot answer definitely why MySQL does not compute the cardinality, but I can guess. The MySQL manual states.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.