DROP TABLE IF EXISTS t1;
create table t1(
id bigint not null primary key, 
i1 bigint, #unique
i2 bigint, #repeating
c1 varchar(20), #unique
c2 varchar(20), #repeating
index t1_1(id, i1),
index t1_2(i1, i2),
index t1_3(i2, i1),
index t1_4(c1, c2),
index t1_5(c2, c1)
) engine=xengine;
optimize table t1;
Table	Op	Msg_type	Msg_text
test.t1	optimize	status	OK
show index in t1;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Visible	Expression
t1	0	PRIMARY	1	id	A	100	NULL	NULL		SE_SPECIFIC			YES	NULL
t1	1	t1_1	1	id	A	50	NULL	NULL		SE_SPECIFIC			YES	NULL
t1	1	t1_1	2	i1	A	100	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_2	1	i1	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_2	2	i2	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_3	1	i2	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_3	2	i1	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_4	1	c1	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_4	2	c2	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_5	1	c2	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_5	2	c1	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
TABLE_NAME	TABLE_ROWS
t1	100
restarting...
# restart
show index in t1;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Visible	Expression
t1	0	PRIMARY	1	id	A	100	NULL	NULL		SE_SPECIFIC			YES	NULL
t1	1	t1_1	1	id	A	50	NULL	NULL		SE_SPECIFIC			YES	NULL
t1	1	t1_1	2	i1	A	100	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_2	1	i1	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_2	2	i2	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_3	1	i2	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_3	2	i1	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_4	1	c1	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_4	2	c2	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_5	1	c2	A	25	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
t1	1	t1_5	2	c1	A	50	NULL	NULL	YES	SE_SPECIFIC			YES	NULL
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
TABLE_NAME	TABLE_ROWS
t1	100
drop table t1;