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