"ManojW" <[EMAIL PROTECTED]> wrote on 04/13/2005 04:23:31 AM:
> Dear Shawn,
> First off, apologies for the delay in reply to this email.
>
> Secondly, thanks a lot for a very illuminating dicussion on
> composite keys and the way MySQL handles them. Reading through the
> whole discussi
om: [EMAIL PROTECTED]
To: ManojW
Cc: MySQL List
Sent: Thursday, April 07, 2005 11:44 PM
Subject: Re: Question on Composite Index
"ManojW" <[EMAIL PROTECTED]> wrote on 04/06/2005 10:09:31 PM:
> Dear All,
> Just to get a better understanding of how indices
"ManojW" <[EMAIL PROTECTED]> wrote on 04/06/2005 10:09:31 PM:
> Dear All,
> Just to get a better understanding of how indices work in MySQL - If
I
> have a Innodb table with a composite primary key
(fld1,fld2,fld3,fld4,fld5),
> then my understanding is that MySQL optimizes just the leftmost
Dear All,
Just to get a better understanding of how indices work in MySQL - If I
have a Innodb table with a composite primary key (fld1,fld2,fld3,fld4,fld5),
then my understanding is that MySQL optimizes just the leftmost primary key
(fld1 in this case).
Hence a query like select * from tbl1 w
