On Wed, Nov 27, 2002 at 03:04:25PM -0800, Steven Roussey wrote: > > Does InnoDB support ALTER TABLE ... ORDER BY ...?
No. > If it weren't for this command, we would never get the continuous > great performance we get from MySQL. And it keeps us from ever > really considering InnoDB. :( Records in InnoDB are ordered based on the primary key, using clustered indexing IIRC. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 7 days, processed 251,342,622 queries (382/sec. avg) --------------------------------------------------------------------- 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