MySQL (5.6) select t1.table_name,t1.indkey,group_concat(index_name order by index_name) index_names, count(*) kensufrom (select table_name,index_name,group_concat(column_name order by seq_in_index) indkeyfrom information_schema.statisticsw…

MySQL (5.6) select object_name,index_namefrom performance_schema.table_io_waits_summary_by_index_usagewhere object_schema = 'test'and index_name is not nulland count_read = 0order by object_name,index_name; (8.0.18)select * from sys.schema…

MySQL (5.6) mysql test -s -N set sql_mode='PIPES_AS_CONCAT'; select 'select ''' || table_name || ',''||count(*) from ' || table_name || ';'from information_schema.tableswhere table_schema ='test'order by table_name; Oracle (12cR1) set head…