Percentage Of Full Table Scans.

by Jan 10, 2014

We are hitting over 50% on our master database for full table scans. Would queries like this:

SELECT DATE_FORMAT(now(),’%Y%m%d’) as today,

DATE_FORMAT(DATE_ADD(now(),INTERVAL 1 DAY),’%Y%m%d’) as tomorrow,

DATE_FORMAT(DATE_SUB(now(),INTERVAL 1 DAY),’%Y%m%d’) as yesterday

 

be considered a full table scan?

Also is there a way to view which statments are being run that are making up the full table scan report