> - Original Message -
> From: "MySQL Newsgroup" <@[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 19, 2002 2:55 PM
> Subject: Re: Select with Order By that don't use my INDEX :(
>
>
> > Subject: Re: Select
Subject: Re: Select with Order By that don't use my INDEX :(
From: Vic Cekvenich <[EMAIL PROTECTED]>
===
Better yet, remove the order by.
Make it sort by the index, ie, create an index that matches your select.
Vic
Dr. Frank Ullrich wrote:
> David,
>
> it can't beca
- Original Message -
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: "David BORDAS" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 10:34 AM
Subject: Re: Select with Order By that don't use my INDEX :(
> David BORDA
David,
it can't because this field is not the first one in your concat index!
Regards,
Frank.
David BORDAS wrote:
>
> I'm using mysql 3.23.49 on Linux redhat dedicated server.
>
> Here is my query :
>
> mysql> show index from MyTable;
>
> Table
David BORDAS a écrit :
>
> I'm using mysql 3.23.49 on Linux redhat dedicated server.
>
> Here is my query :
>
> mysql> show index from MyTable;
>
> Table: MyTable
> Non_unique : 0
> Key_name: PRIMARY
> Seq_in_index: 1
> Column_name
I'm using mysql 3.23.49 on Linux redhat dedicated server.
Here is my query :
mysql> show index from MyTable;
Table: MyTable
Non_unique : 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name : Field0
Collation : A
Cardinality
