Page 9521 Database Missing Indexes

Base Application, System.DataAdministration

src/Layers/W1/BaseApp/Modules/System/DatabaseInformation/DatabaseMissingIndexes.page.al100 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.DataAdministration;using System.Diagnostics;page 9521 "Database Missing Indexes"{    Caption = 'Database Missing Indexes';    DeleteAllowed = false;    Editable = false;    InsertAllowed = false;    ModifyAllowed = false;    PageType = List;    SourceTable = "Database Missing Indexes";    ApplicationArea = All;    UsageCategory = Administration;    SourceTableView = sorting("Estimated Benefit")                      order(descending);    layout    {        area(content)        {            group(Control2)            {                InstructionalText = 'This page shows indexes that the SQL query optimizer suggests are added to the database. See the SQL documentation on sys.dm_db_missing_index_details for more information on missing indexes.';                ShowCaption = false;            }            repeater(Group)            {                field("Table Name"; Rec."Table Name")                {                    ApplicationArea = All;                    Caption = 'Table Name';                    ToolTip = 'Name of the table on the database.';                }                field("Extension Id"; Rec."Extension Id")                {                    ApplicationArea = All;                    Caption = 'Extension Id';                    ToolTip = 'Id of the extension that table belongs to.';                }                field("Index Equality Columns"; Rec."Index Equality Columns")                {                    ApplicationArea = All;                    Caption = 'Index Equality Columns';                    ToolTip = 'A list of columns that are used in WHERE equality predicates in the SQL query needing the index.';                }                field("Index Inequality Columns"; Rec."Index Inequality Columns")                {                    ApplicationArea = All;                    Caption = 'Index Inequality Columns';                    ToolTip = 'A list of columns that are used in WHERE inequality predicates (such as < or >) or ORDER BY in the SQL query needing the index.';                }                field("Index Include Columns"; Rec."Index Include Columns")                {                    ApplicationArea = All;                    Caption = 'Index Include Columns';                    ToolTip = 'A list of columns that are part of the SELECT clause in the SQL query needing the index.';                }                field("Seeks"; Rec."User Seeks")                {                    ApplicationArea = All;                    Caption = 'Seeks';                    ToolTip = 'Number of seeks caused by queries that the recommended index could have been used for.';                }                field("Scans"; Rec."User Scans")                {                    ApplicationArea = All;                    Caption = 'Scans';                    ToolTip = 'Number of scans caused by queries that the recommended index could have been used for.';                }                field("Average Total Cost"; Rec."Average Total User Cost")                {                    ApplicationArea = All;                    AutoFormatType = 0;                    Caption = 'Average Total Cost';                    ToolTip = 'Average cost of the queries that could be reduced by the index.';                }                field("Average Impact"; Rec."Average User Impact")                {                    ApplicationArea = All;                    AutoFormatType = 0;                    Caption = 'Average Impact';                    ToolTip = 'Average percentage benefit that queries could experience if this missing index is added.';                }                field("Estimated Benefit"; Rec."Estimated Benefit")                {                    ApplicationArea = All;                    AutoFormatType = 0;                    Caption = 'Estimated Benefit';                    ToolTip = 'The estimated benefit gained by adding the missing index.';                }            }        }    }    actions    {    }}