Making file for import...
-rw-rw-r--    1 openxs   openxs    3801088 Nov 27 16:14 xx
File prepared
Creating table...
Table created
test.t1: Records: 131072  Deleted: 0  Skipped: 0  Warnings: 393216
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	1	xx	1	xx	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	xx	2	yy	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy	1	yy	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy	2	xx	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	zz	1	zz	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	zz	2	xx	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy_2	1	yy	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy_2	2	zz	A	NULL	NULL	NULL	YES	BTREE	disabled
count(*)
131072
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	1	xx	1	xx	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	xx	2	yy	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy	1	yy	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy	2	xx	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	zz	1	zz	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	zz	2	xx	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy_2	1	yy	A	NULL	NULL	NULL	YES	BTREE	disabled
t1	1	yy_2	2	zz	A	NULL	NULL	NULL	YES	BTREE	disabled
Execution plans after loading
Execution plans after loading
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	131072	Using where
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	131072	Using where
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	131072	Using where
Execution plans after flushing
Execution plans after flushing
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	zz	NULL	NULL	NULL	131072	Using where
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	yy,yy_2	yy	3	const	1	Using where
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	xx	xx	14	const	1	Using where
So, indexes are not even considered until fuls tables performed. Is it OK?