MySQL Forums
Forum List  »  Partitioning

Re: How to handle secondary keys in partitioning?
Posted by: John Smith
Date: May 09, 2010 12:41PM

That's great news.

> "allow pruning on INSERT/UPDATE/DELETE."

Does that mean currently no pruning is done for INSERT/UPDATE/DELETE?

So if I insert a new record, the SQL statement is run for all partitions? But how is that possible since the new record can only be inserted into one partition?

And what about UPDATE/DELETE - are those statements run on all partitions without pruning?

So if I have N partitions, an INSERT/UPDATE/DELETE statement would be run N times sequentially, once on each partition?

Options: ReplyQuote

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.