rds. :-)
Hope that helps.
Matt
- Original Message -
From: "Chris Elsworth"
Sent: Wednesday, December 10, 2003 12:49 PM
Subject: ALTER TABLE .. ORDER BY
> Hello,
>
> Just a quickie. Does anyone know if issueing an ALTER TABLE t ORDER BY
c
> is as good as an OP
Hello,
Just a quickie. Does anyone know if issueing an ALTER TABLE t ORDER BY c
is as good as an OPTIMIZE TABLE if I know the order I'll mostly be
sorting with? Does the ALTER TABLE operation reclaimed deleted rows,
for example? Or should I OPTIMIZE and then ALTER?
Cheers :)
--
Chris
--
MySQL
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
Does InnoDB support ALTER TABLE ... ORDER BY ...? 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. :(
Sincerely,
Steven Roussey
http://Network5
