Interview Questions
1. What are missing indexes in a database?
When the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the
best indexes do not exist, the query optimizer generates a suboptimal query plan, but still stores information about these
indexes. The missing indexes feature enables you to access information about these indexes so you can decide whether they
should be implemented
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment