Re: auto_increment and clustering sequence

2002-06-22 Thread Paul DuBois
At 15:41 +0100 6/21/02, Bill Ferrett wrote: >I would like to have a MySql table where each row has a unique id (using >auto-increment) but is clustered, i.e. physically stored, in a different >sequence, e.g. name. This is so that an sql query to order by namew will be >quicker. > >I don't want th

Re: auto_increment and clustering sequence

2002-06-21 Thread Dan Nelson
In the last episode (Jun 21), Bill Ferrett said: > I would like to have a MySql table where each row has a unique id > (using auto-increment) but is clustered, i.e. physically stored, in a > different sequence, e.g. name. This is so that an sql query to order > by namew will be quicker. > > I do

auto_increment and clustering sequence

2002-06-21 Thread Bill Ferrett
I would like to have a MySql table where each row has a unique id (using auto-increment) but is clustered, i.e. physically stored, in a different sequence, e.g. name. This is so that an sql query to order by namew will be quicker. I don't want the auto-increment id to be duplicated - I believe t