MySQL cardinality

I'm getting a Cardinality of 1 on all FULLTEXT indexes I create even
though I know there are hundreds of unique values. An explain is also
returning only 1 row which should be many many more as well.

Is this normal, and why might it be happening?

A

Re: MySQL cardinality

"UKuser" wrote in message
news:1192093678.040064.111220@v3g2000hsg.googlegroups.com...
> I'm getting a Cardinality of 1 on all FULLTEXT indexes I create even
> though I know there are hundreds of unique values. An explain is also
> returning only 1 row which should be many many more as well.
>
> Is this normal, and why might it be happening?
>
> A
>

Now, Jerry, etc. THIS poster has put up a pure SQL question.

UKuser, this is a php group, not a sql or mysql group.

Shelly

Re: MySQL cardinality

On 11 Oct, 10:22, "Shelly" wrote:
> "UKuser" wrote in message
>
> news:1192093678.040064.111220@v3g2000hsg.googlegroups.com...
>
> > I'm getting a Cardinality of 1 on all FULLTEXT indexes I create even
> > though I know there are hundreds of unique values. An explain is also
> > returning only 1 row which should be many many more as well.
>
> > Is this normal, and why might it be happening?
>
> > A
>
> Now, Jerry, etc. THIS poster has put up a pure SQL question.
>
> UKuser, this is a php group, not a sql or mysql group.
>
> Shelly

Yeah, but it was your turn this time. We can't have all the fun!