Query Performance too Slow

Query Performance too Slow

References

Reference NO 1

http://technet.microsoft.com/en-us/library/ms177500(v=sql.105).aspx

Reference NO 2

http://stackoverflow.com/questions/806015/sql-query-joins-multiple-tables-too-slow-8-tables

Reference NO 3

http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/

Reference NO 4

http://www.mysqlperformanceblog.com/2012/09/20/a-prototype-lower-impact-slow-query-log/

Reference NO 5

http://my.safaribooksonline.com/book/databases/mysql/9780596101718/query-performance-optimization/slow_query_basics_optimize_data_access

Reference NO 6

http://blogs.mpr.org/developer/2013/06/using-mysqls-slow-query-log-to-pinpoint-sql-performance-bottlenecks/

Reference NO 7

http://techblog.careesma.com/2010/05/27/optimizing-slow-queries-in-mysql/

Reference NO 8

http://erniemiller.org/2011/08/30/slow-mysql-query-ill-give-you-a-hint/