MySQL Forums
Forum List  »  Full-Text Search

Cardinality
Posted by: Antony Hatton
Date: October 11, 2007 04:33AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Cardinality
13004
October 11, 2007 04:33AM
5340
October 12, 2007 05:01AM
4834
October 15, 2007 02:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.