Missing Index

Check Frequency

Daily

Default Configuration

Detects when a table might be missing an index based on the query workload over the last seven days and creates an issue with severity "info". Resolves once the recommended index has been created, or the workload has changed such that the index is no longer relevant.

This check is enabled by default.

Guidance

You can learn about Index Advisor and missing index insights in the Index Advisor documentation.

---

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →