Page 9521 "Database Missing Indexes"
Base Application · System.DataAdministration
Across versions
- BC23-25present
- BC26declaration changed
- BC27-30unchanged
Neighbourhood 2 connected objects and pages
Base Application · System.DataAdministration · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Database Missing Indexes |
| SourceTable | Database Missing Indexes |
| PageType | List |
| UsageCategory | Administration |
| ApplicationArea | All |
Fields on this page
Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).
| Group | Control | Shows | ToolTip |
|---|---|---|---|
| Group | Table Name | Rec."Table Name" |
Name of the table on the database. |
| Extension Id | Rec."Extension Id" |
Id of the extension that table belongs to. | |
| Index Equality Columns | Rec."Index Equality Columns" |
A list of columns that are used in WHERE equality predicates in the SQL query needing the index. | |
| Index Inequality Columns | Rec."Index Inequality Columns" |
A list of columns that are used in WHERE inequality predicates (such as < or >) or ORDER BY in the SQL query needing the index. | |
| Index Include Columns | Rec."Index Include Columns" |
A list of columns that are part of the SELECT clause in the SQL query needing the index. | |
| Seeks | Rec."User Seeks" |
Number of seeks caused by queries that the recommended index could have been used for. | |
| Scans | Rec."User Scans" |
Number of scans caused by queries that the recommended index could have been used for. | |
| Average Total Cost | Rec."Average Total User Cost" |
Average cost of the queries that could be reduced by the index. | |
| Average Impact | Rec."Average User Impact" |
Average percentage benefit that queries could experience if this missing index is added. | |
| Estimated Benefit | Rec."Estimated Benefit" |
The estimated benefit gained by adding the missing index. |
Documented on Microsoft Learn
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Database Missing Indexes"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.