Question

Which statement is used to remove indexes on tables?

(a) DROP INDEX

(b) DELETE INDEX

(c) REMOVE INDEX

(d) FLUSH INDEX

The question was posed to me in unit test.

My doubt is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL

Answer 1

Correct choice is (a) DROP INDEX

The best I can explain: MySQL provides statements to change the structure of tables. To add or remove the indexes on the existing database tables, the ‘CREATE INDEX’ and ‘DROP INDEX’ tables are used.