Page 1 of 1

index cardinality

Posted: Sat Dec 08, 2007 9:30 pm
by GeXus
I just added a new index to a table with about 300k records.. but the cardinality is only 14.... shouldn't it be 300k?

Posted: Sat Dec 08, 2007 9:42 pm
by superdezign
Well, you aren't giving us much information. Different table types act differently (MyISAM, InnoDb, etc).

Posted: Sat Dec 08, 2007 9:48 pm
by GeXus
MyISAM.... sorry