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 this happens when the auto_increment column is not the first column - so a multi-column index of name,id seems to be out. Can I do this and if so how? Many thanks -- Bill Ferrett Accroserve Systems Ltd. Office: 01702 342148 Mobile: 07855 868565 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
