- A To define a primary key for a table
- B To ensure data integrity
- C To optimize query performance
- D To enforce referential integrity
- Share this MCQ
Answer:
C
Share this MCQ
In MySQL, an INDEX is used to optimize the performance of queries by creating a data structure that allows for faster data retrieval. It helps in speeding up the search, sorting, and joining of tables.
Click me to Read more Question & Answer of Introduction to MySQL DatabasesShare this MCQ