Oh, my god. The test results look ugly. I type it again.
TABLE: xxxtable;
Sequential scan: SELECT * FROM INFOSCHEMA.xxxtable;
Non-sequential scan: SELECT * FROM INFOSCHEMA.xxxtable ORDER BY xxxfield;
Index: SELECT * FROM INFOSCHEMA.xxxtable WHERE xxfield = "xxx";
S: support
N: not support
TABLE Sequential scan Non-sequential scan Index
CHARACTER_SETS: S S N
COL_CHA_SET_APP: S S N
COLLATIONS: S S N
COLUMN_PRIVILEGES: S S N
ENGINES: S S N
GLOBAL_STATUS: S N N
GLOBAL_VARIABLES: S N N
OPEN_TABLES: S S N
PLUGINS: S S N
PROCESSLIST: S S N
SESSION_STATUS: S N N
SESSION_VARIABLES: S N N
STATUS: S N N
VARIABLES: S N N
TABLES: S S S
PARTITIONS: S S S
TABLE_NAMES: S S Partial
Regards,
Robin
