MySQL Forums
Forum List  »  Partitioning

Re: Partition Management in MySQL 5.1
Posted by: Mikael Ronström
Date: October 27, 2005 02:37PM

Hi,

Steven Roussey wrote:
> One thing I don't really care about, but am
> curious on, is why this format:
>
> ALTER TABLE t1 OPTIMIZE PARTITION (x0, x1);
>
> Rather than this:
>
> OPTIMIZE TABLE t1 PARTITION (x0, x1);
>

Well mostly because ALTER TABLE was used for all other PARTITION stuff and
it was very straightforward to integrate it in the parser. So no other stronger
argument other than that it was extremely easy to add those after adding all
the other ALTER TABLE XXX PARTITION commands.

Rgrds Mikael

> etc.?

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
14660
October 06, 2005 06:41PM
Re: Partition Management in MySQL 5.1
3406
October 27, 2005 02:37PM
3164
November 07, 2005 07:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.