An application packs several fields of information into the details column of the table sensors. The first six characters of that data represent a location code. Example: "ABCDEFOO -ooozzz comments will be here FIELDS----FIELD64" Given the query pattern:

SELECT...FROM sensors WHERE details LIKE `ABCDEF%' Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?

Question

An application packs several fields of information into the details column of the table sensors. The first six characters of that data represent a location code. Example: "ABCDEFOO -ooozzz comments will be here FIELDS----FIELD64" Given the query pattern:

SELECT...FROM sensors WHERE details LIKE `ABCDEF%' Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?

Accepted Answer

A. ALTER TABLE sensors ADD KEY (details ) USING BTREE B. ALTER TABLE sensors ADD KEY (details) USING HASH

Answer

C. ALTER TABLE sensors ADD KEY (details(8)) USING BTREE

Answer

D. ALTER TABLE sensors ADD KEY (details(8))USING HASH

Answer

E. ALTER TABLE sensors ADD FULLTEX (details)

An application packs several fields of information into the details column of the table sensors. The first six characters of that data represent a location code. Example: "ABCDEFOO -ooozzz comments…

Question

Options

How the community answered

Community Discussion