MYSQL DATABASE INTERVIEW QUESTIONS

What is an index in MySQL, and why is it used?

What are the different types of indexes available in MySQL?

How do you create an index in MySQL?

What is a composite index, and when would you use it?

What are the advantages and disadvantages of using indexes in MySQL?

How do you check if a table has indexes in MySQL?

What is the difference between a unique index and a primary key index?

What is a full-text index, and how is it different from other indexes?

How does the order of columns in a composite index affect query performance?

How can you drop an index in MySQL?