WITH X1 AS
(
SELECT DISTINCT A.TABLE_SCHEMA,
TABLE_NAME,index_name,
GROUP_CONCAT(DISTINCT COLUMN_NAME ) C
FROM INFORMATION_SCHEMA.STATISTICS A
group by TABLE_NAME,index_name
),
X2 AS (
SELECT C, TABLE_SCHEMA,TABLE_NAME,COUNT(0) COUNT1
FROM X1 X
GROUP BY C, TABLE_SCHEMA,TABLE_NAME
HAVING COUNT(0)>1
)
SELECT X1.*
FROM X1 JOIN X2 ON X1.TABLE_NAME =X2.TABLE_NAME
AND X1.TABLE_SCHEMA =X2.TABLE_SCHEMA
AND X2.C =X1.C