Bug #11353 Create indices after bulk insert
Submitted: 15 Jun 2005 14:17 Modified: 15 Oct 2009 5:52
Reporter: Niklas Johansson Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S4 (Feature request)
Version:1.1.16 OS:Any
Assigned to: CPU Architecture:Any
Tags: CHECKED
Triage: Triaged: D5 (Feature request) / R3 (Medium) / E3 (Medium)

[15 Jun 2005 14:17] Niklas Johansson
Description:
As a way to improve performance the migration tool should create the indices after the data has been transfered and not when the tables are crated.

How to repeat:
Try to transfer a table with a lot of rows and a couple of indices.
[11 Feb 2009 13:50] Susanne Ebrecht
Many thanks for pointing this out.

Creating indexes after you filled the tables is not a good idea in MySQL either.

But disable/enable keys would be a good idea.

We will think about it.
[15 Oct 2009 5:52] Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Migration Tool into MySQL Workbench. We won't add this feature request anymore.

In MySQL Workbench we overworked SQL output.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/