How do you identify missing indexes in a database, and what factors do you consider before creating them? How do you balance read performance gains against write overhead?

Sample answer preview

Identifying missing indexes involves a combination of automated suggestions, execution plan analysis, and workload understanding. The goal is to find indexes that provide meaningful read performance improvement without introducing excessive write overhead or storage consumption.