| 1 |
DESC sys.schema_redundant_indexes; |
| 2 |
Field Type Null Key Default Extra |
| 3 |
table_schema varchar(64) NO NULL |
| 4 |
table_name varchar(64) NO NULL |
| 5 |
redundant_index_name varchar(64) YES NULL |
| 6 |
redundant_index_columns text YES NULL |
| 7 |
redundant_index_non_unique int YES NULL |
| 8 |
dominant_index_name varchar(64) YES NULL |
| 9 |
dominant_index_columns text YES NULL |
| 10 |
dominant_index_non_unique int YES NULL |
| 11 |
subpart_exists int NO 0 |
| 12 |
sql_drop_index varchar(223) YES NULL |
| 13 |
SELECT * FROM sys.schema_redundant_indexes; |
| 14 |
DESC sys.x$schema_flattened_keys; |
| 15 |
Field Type Null Key Default Extra |
| 16 |
table_schema varchar(64) NO NULL |
| 17 |
table_name varchar(64) NO NULL |
| 18 |
index_name varchar(64) YES NULL |
| 19 |
non_unique int YES NULL |
| 20 |
subpart_exists bigint YES NULL |
| 21 |
index_columns text YES NULL |
| 22 |
SELECT * FROM sys.x$schema_flattened_keys; |
| 23 |
CREATE DATABASE rkey; |
| 24 |
CREATE TABLE rkey.rkey ( |
| 25 |
i INT, |
| 26 |
j INT, |
| 27 |
k INT, |
| 28 |
PRIMARY KEY (i), |
| 29 |
KEY (j), |
| 30 |
KEY (j, k), |
| 31 |
KEY (i, j, k) |
| 32 |
); |
| 33 |
SELECT * FROM sys.schema_redundant_indexes ORDER BY table_name, dominant_index_name; |
| 34 |
table_schema table_name redundant_index_name redundant_index_columns redundant_index_non_unique dominant_index_name dominant_index_columns dominant_index_non_unique subpart_exists sql_drop_index |
| 35 |
rkey rkey j j 1 j_2 j,k 1 0 ALTER TABLE `rkey`.`rkey` DROP INDEX `j` |
| 36 |
rkey rkey i i,j,k 1 PRIMARY i 0 0 ALTER TABLE `rkey`.`rkey` DROP INDEX `i` |
| 37 |
DROP DATABASE rkey; |