MySQL Forums
Forum List  »  Backup

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

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL Script to get the queries which are using full table scan
1577
March 15, 2016 05:26AM


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.