Re: Re bug#45458

2010-03-03 Thread Zardosht Kasheff
egiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De > Meersman > Sent: Wednesday, March 03, 2010 6:16 AM > To: Zardosht Kasheff > Cc: Jonas Oreland; mysql@lists.mysql.com > Subject: Re: Re bug#45458 > > Unless I'm very much mistaken, InnoDB tables always have a clu

RE: Re bug#45458

2010-03-03 Thread Gavin Towey
Yes, but the optimizer doesn't know that. -Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, March 03, 2010 6:16 AM To: Zardosht Kasheff Cc: Jonas Oreland; mysql@lists.mysql.com Subject: Re: Re bug#45458 Unles

Re: Re bug#45458

2010-03-03 Thread Johan De Meersman
Unless I'm very much mistaken, InnoDB tables always have a clustered index as their primary key. On Wed, Mar 3, 2010 at 2:58 PM, Zardosht Kasheff wrote: > Hello Jonas, > > Thank you for filing this feature request. Are there plans to add > support for clustered indexes in MySQL soon? This is som

Re: Re bug#45458

2010-03-03 Thread Zardosht Kasheff
Hello Jonas, Thank you for filing this feature request. Are there plans to add support for clustered indexes in MySQL soon? This is something I have been researching on and off for a while now. Here are my thoughts. It seems that there are two parts to this feature request: 1) a new flag that all