Cardinality

[Antony Hatton]

Hi,

I am still quite new to Indexes, but am trying to get my FULLTEXT indexes to work, however for every index I create they all come out with a Cardinality of 1. When I look at the index in notepad it looks like theres more than 1 rows worth of info, but it doesnt display when using show index for table_name.

I am using slightly modified code from
http://www.onlamp.com/pub/a/onlamp/2003/06/26/fulltext.html
(it errored saying DB type not good - so I set it to MyISAM and also removed default values)
and even that results in a NULL cardinality.

Any thoughts on where I could be going wrong would be great.

Thanks

A