Which three statements are true about clustered indexes as used in InnoDB?

The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?

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



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Jose Wilson

Jose Wilson

Excelent explanation, tks 😀

Malika

Malika

BDE
F is close but a first unique index is used only when primary key is not there.

banney

banney

I think B D E;