Just added more indexes and found a good one.
thanx for the advise ! =)
/C
- Original Message -
From: "Claus Reestrup" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 29, 2002 2:28 PM
Subject: Wont use Index when data is not evenly distributed
* Claus Reestrup
> Cant figure out why MySQL wont use index on a big table.
> Ok, the data is not evenly distributed which might be the problem.
>
> Look here:
>
> I have a table with 1 million records, with the following fields:
> IdUser, int
> X, int
> Y, int
> Z, int
> C, char(10)
>
> no, varcha
Claus Reestrup wrote:
> Cant figure out why MySQL wont use index on a big table.
> Ok, the data is not evenly distributed which might be the problem.
>
> Look here:
>
> I have a table with 1 million records, with the following fields:
> IdUser, int
> X, int
> Y, int
> Z, int
> C, char(10)
>
> no
Cant figure out why MySQL wont use index on a big table.
Ok, the data is not evenly distributed which might be the problem.
Look here:
I have a table with 1 million records, with the following fields:
IdUser, int
X, int
Y, int
Z, int
C, char(10)
no, varchars, text, or blobs.
IdUser is a user id
