INSERT..SELECT performance issues [closed]

INSERT..SELECT performance issues [closed]

References

Reference NO 1

http://stackoverflow.com/questions/15187423/insert-select-performance-issues

Reference NO 2

http://www.mysqlperformanceblog.com/2006/07/12/insert-into-select-performance-with-innodb-tables/

Reference NO 3

http://sqlmag.com/sql-server/insert-speed-and-select-performance-too

Reference NO 4

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1363403159158

Reference NO 5

http://forums.mysql.com/read.php?24,1162948513,newer

Reference NO 6

http://sqlblog.com/blogs/adam_machanic/archive/2013/05/15/insert-select-is-broken-ask-microsoft-to-fix-it.aspx

Reference NO 7

http://www.bigresource.com/MS_SQL-Table-Spool-in-simple-INSERT-SELECT-causing-performance-problems-iEPwsg6Y.html

Reference NO 8

http://www.ibm.com/developerworks/data/library/tips/dm-0403wilkins/