Given table: CREATE TABLE testtab (d_col CHAR(4));
Question 1: It appears that there is no harm in just appending
directives onto the alter table command even if the order doesn't make
sense. It appears the parser figures it out... For example...
ALTER TABLE testtab ADD COLUMN c_col char(4)
-
From: Matt Neimeyer [mailto:m...@neimeyer.org]
Sent: Friday, September 04, 2009 3:53 PM
To: mysql@lists.mysql.com
Subject: ALTER TABLE order / optimization
Given table: CREATE TABLE testtab (d_col CHAR(4));
Question 1: It appears that there is no harm in just appending
directives onto the alter
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 OPTIMIZE TABLE if I know the order I'll mostly
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
--
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://Network54.com
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