MySQL Forums :: Partitioning :: Is there a SWITCH equivalent in MySQL?


Advanced Search

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? 3442 John Gagnon 12/22/2010 02:27PM
Re: Is there a SWITCH equivalent in MySQL? 1305 Rick James 12/24/2010 10:48AM
Re: Is there a SWITCH equivalent in MySQL? 1458 Mattias Jonsson 01/02/2011 04:41PM


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.