adding support to use SHOW INDEXES and innodb_stats_on_metadata instead of ANALYZE TABLE