The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?
A.
A primary key must exist for creation of a clustered index.
B.
A primary key is used as a clustered index.
C.
A clustered index is a grouping of indexes from different tables into a global index for faster
searching.
D.
If no indexes exist, a hidden clustered index is generated based on row IDs.
E.
A clustered index provides direct access to a page containing row data.
F.
The first unique index is always used as a clustered index and not a primary key.
G.
A clustered index allows fulltext searching within InnoDB,
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.0/en/innodb-index-types.html
B, D, E
Explanation: http://dev.mysql.com/doc/refman/5.6/en/innodb-index-types.html
B,D,E
“Accessing a row through the clustered index is fast because the index search leads directly to the page with all the row data”
http://dev.mysql.com/doc/refman/5.6/en/innodb-index-types.html
Excelent explanation, tks 😀
B,D,E
BDE
F is close but a first unique index is used only when primary key is not there.
I think B D E;