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