Index Tuning Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Query Optimization

What you'll be asked

  1. Which of the following is the primary purpose of creating an index on a database table column?
  2. When analyzing a query execution plan, what does an 'Index Scan' typically indicate compared to an 'Index Seek'?
  3. You have a query that filters by 'Lastname' and 'Firstname'. Which index strategy is most effective for this query?
  4. Why might adding too many indexes to a table negatively impact database performance?
  5. Consider a table with a composite index on (Status, CreatedDate). Which of the following queries will NOT effectively utilize this index?

Answers and explanations come after you submit.