11
I have added a FULLTEXT index to one of my MySQL database tables as follows:
ALTER TABLE members ADD FULLTEXT(about,fname,lname,job_title);
The problem is that using phpmyadmin I can see the cardinality of my new index is only 1. Does this mean the index will never be used?
I have run a analyze table command but it didn't seem to do anything.
analyze table members
The respective types of the index fields are varchar(100), varchar(100), text, varchar(200) and the engine used is MyISAM and the table has about 30,000 rows, all unique. My MySQL version is 5.0.45.
Am I doing something wrong?