The statement used to remove indexes on tables is ______________
(a) DROP INDEX
(b) DELETE INDEX
(c) REMOVE INDEX
(d) FLUSH INDEX
(a) DROP INDEX
(b) DELETE INDEX
(c) REMOVE INDEX
(d) FLUSH INDEX
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
The correct choice is (a) DROP INDEX
Best explanation: 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.