SELECT iss.table_schema, iss.table_name, iss.index_name, iss.seq_in_index, INDEX_TYPE, isin.index_name, iss.cardinality, isin.ROWS_READ
FROM INFORMATION_SCHEMA.STATISTICS iss
LEFT OUTER JOIN information_schema.INDEX_STATISTICS isin
ON iss.TABLE_SCHEMA=isin.TABLE_SCHEMA
AND iss.TABLE_NAME=isin.TABLE_NAME
AND iss.INDEX_NAME=isin.INDEX_NAME
WHERE iss.TABLE_SCHEMA = ‘bi’ #‘optimus'
AND isin.index_name IS NULL