A

Admin • 833K Points
Coach

Q. Which of the following is a valid way to create an index?

  • (A) CREATE KEY idx_name ON table(column);
  • (B) MAKE INDEX idx_name ON table(column);
  • (C) CREATE INDEX idx_name ON table(column);
  • (D) SET INDEX ON table(column);
  • Correct Answer - Option(C)
  • Views: 27
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

`CREATE INDEX` is the correct syntax to create an index in MySQL.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.