Indexes and Performance
- Explain how indexing can negatively affect performance.
- Explain how to implement indexing strategies for large datasets.
- Explain indexing and how it can improve query performance.
- How can you optimize a SQL query?
- What are the different types of indexes?
- What is a clustered index, and how does it differ from a non-clustered index?
- What is an index?