Table "Database Missing Indexes"
Virtual table that provides information about database indexes that could improve query performance but are currently missing.
Remarks
This table exposes database engine recommendations for missing indexes that could significantly improve query performance. Essential for database administrators and performance analysts to identify optimization opportunities and understand query patterns that would benefit from additional indexing. The table includes impact analysis and cost-benefit information to help prioritize index creation decisions. Used for proactive database performance tuning and optimization planning.
Properties
| Name | Value |
|---|---|
| DataPerCompany | False |
| Scope | Cloud |
Fields
| Name | Type | Description |
|---|---|---|
| "Index Handle" | Integer | A unique handle identifying this missing index recommendation. |
| "Table Name" | Text[128] | The name of the table that would benefit from the missing index. |
| "Extension Id" | Guid | The extension ID associated with the table requiring the missing index. |
| "Index Equality Columns" | Text[2048] | The columns that should be included in the index for equality predicates. |
| "Index Inequality Columns" | Text[2048] | The columns that should be included in the index for inequality predicates. |
| "Index Include Columns" | Text[2048] | Additional columns that should be included in the index for covering queries. |
| Statement | Text[2048] | The SQL statement or query pattern that would benefit from this index. |
| "User Seeks" | BigInteger | The number of times user queries have sought this index. |
| "User Scans" | BigInteger | The number of times user queries have scanned this table due to the missing index. |
| "Average Total User Cost" | Decimal | The average total cost for user queries that would benefit from this index. |
| "Average User Impact" | Decimal | The average percentage improvement in query performance that this index would provide. |
| "Estimated Benefit" | Decimal | The estimated benefit score for creating this index, calculated from usage and impact metrics. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |