Page 9521 Database Missing Indexes

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
    {
    }
}