Interface IndexProposalEvidence

interface IndexProposalEvidence {
    KeyConfidence?: number;
    KeyOrigin?: "declared" | "discovered";
    LeadingColumnDistinctCount?: number;
    References?: string;
    RowCount: number;
}

Properties

KeyConfidence?: number

Confidence of the discovered key that motivated the proposal (0–100).

KeyOrigin?: "declared" | "discovered"

Whether the motivating key is declared in the database or was discovered.

LeadingColumnDistinctCount?: number

Distinct values of the leading column, when column statistics are available.

References?: string

schema.table.column the foreign key points at (FK coverage proposals).

RowCount: number