MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

SQL Script to get the queries which are using full table scan
Posted by: Vinodh selvaraj
Date: March 15, 2016 05:26AM

Hi,

I am working in a data warehouse environment which is on MySQL.

Now we are seeing the performance issues on MySQL and i am new to MySQL performance tuning.

I need to get the list of queries which are using full table scan and start the tuning.

can you please help me to get the script or any other options to get the queries which are using full table scan ?

Thanks,
Vinodh Selvaraj

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
SQL Script to get the queries which are using full table scan
1687
Vinodh selvaraj
March 15, 2016 05:26AM
Re: SQL Script to get the queries which are using full table scan
1063
Vitaly Karasik
March 15, 2016 06:52AM
Re: SQL Script to get the queries which are using full table scan
1079
Rick James
March 16, 2016 05:12PM


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.