index cardinality

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

index cardinality

Post 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?
User avatar
superdezign
DevNet Master
Posts: 4135
Joined: Sat Jan 20, 2007 11:06 pm

Post by superdezign »

Well, you aren't giving us much information. Different table types act differently (MyISAM, InnoDb, etc).
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post by GeXus »

MyISAM.... sorry
Post Reply