Interface IndexProposal

A proposed new index.

interface IndexProposal {
    Columns: string[];
    Evidence: IndexProposalEvidence;
    IncludeColumns: string[];
    Priority: number;
    Reason: string;
    SchemaName: string;
    Source: IndexProposalSource;
    TableName: string;
}

Index

Properties

Columns Evidence IncludeColumns Priority Reason SchemaName Source TableName

Properties

Columns

Columns: string[]

Key columns, in index order.

Evidence

Evidence: IndexProposalEvidence

IncludeColumns

IncludeColumns: string[]

Non-key covering columns (SQL Server / PostgreSQL INCLUDE).

Priority

Priority: number

1 (low) – 100 (high); larger tables score higher.

Reason

Reason: string

SchemaName

SchemaName: string

Source

Source: IndexProposalSource

TableName

TableName: string