next
Round
Technologies
Experiences
Contribute
Login
next
Round
Technologies
Experiences
Contribute
Login
Question Loading...
Indexes
1. What is an index in MySQL and why is it used?
Level: Expert | Frequency: High
2. How do you create an index on a table column?
Level: Expert | Frequency: High
3. What are the different types of indexes available in MySQL?
Level: Expert | Frequency: High
4. How can you view all indexes defined on a table?
Level: Expert | Frequency: High
5. What is the difference between a primary key and a unique index?
Level: Expert | Frequency: High
6. How do indexes improve query performance? Explain with an example.
Level: Expert | Frequency: High
7. What is a composite index, and how does column order affect its usage?
Level: Expert | Frequency: High
8. How do clustered and non-clustered indexes differ in MySQL’s InnoDB engine?
Level: Expert | Frequency: High
9. What is a full-text index and when would you use it?
Level: Expert | Frequency: High
10. Explain the concept of index selectivity and how it impacts performance.
Level: Expert | Frequency: High
11. How does MySQL use indexes internally when executing a JOIN query?
Level: Expert | Frequency: High
12. What is a covering index, and how can it reduce disk I/O?
Level: Expert | Frequency: High
13. What are the trade-offs of adding too many indexes to a table?
Level: Expert | Frequency: High
14. How can partial indexes or prefix indexes be used for large text columns?
Level: Expert | Frequency: High
15. Describe how InnoDB’s clustered index structure affects row storage and lookups.
Level: Expert | Frequency: High
16. What are invisible indexes in MySQL 8.0, and how can they be used for testing?
Level: Expert | Frequency: High
17. How does MySQL optimize queries differently when using B-Tree vs. HASH indexes?
Level: Expert | Frequency: High
18. What happens to indexes during bulk inserts, and how can you optimize performance for such operations?
Level: Expert | Frequency: High
19. How do you identify and remove unused or redundant indexes without affecting application performance?
Level: Expert | Frequency: High
All Topics
Basics
Databases
Tables
Data Types
Queries
Views
Indexes
Clauses
Regex
Functions and Operators
Keys
Joins
Joins
Triggers