MySQL Forums
Forum List  »  Partitioning

Is there a SWITCH equivalent in MySQL?
Posted by: John Gagnon
Date: December 22, 2010 02:27PM

My company is looking to move from SQL Server to MySQL to use table partitioning without having to upgrade to Enterprise Edition.

We want to use table partitioning to speed inserts into a large table (hundreds of millions of rows). A couple of questions.

Q1) Can indexes be created on the partition or only across the entire row range?
Q2) Is it possible to insert data into an empty table and then "switch" this table in as a new partition into a table that uses partitioning by date? Integer is fine since we have a dateId that resolves to every date.

Options: ReplyQuote


Subject
Views
Written By
Posted
Is there a SWITCH equivalent in MySQL?
3506
December 22, 2010 02:27PM


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.