INNODB_SYS_INDEXES table provides status
InnoDB indexes, equivalent to
the information from the
SYS_INDEXES table in
InnoDB data dictionary.
|An identifier for each index that is unique across all the databases in an instance.|
|The name of the index. User-created indexes have names in all lowercase.
Indexes created implicitly by |
|An identifier representing the table associated with the index; the same
value from |
|A numeric identifier signifying the kind of index. 0 = Secondary Index, 1 = Clustered Index, 2 = Unique Index, 3 = Primary Index, 32 = Full-text Index.|
|The number of columns in the index key. For the
|The root page number of the index B-tree. For full-text indexes, the
|An identifier for the tablespace where the index resides. 0 means the
You must have the
PROCESS privilege to
query this table.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices