BuildOptAndHypTableMaps builds a HypotheticalTable for each table in indexCandidates.

FindIndexCandidateSet returns a map storing potential indexes for each table referenced in a query.

FindRecs finds index candidates that are scanned in an expression to determine a statement's index recommendation set.

TypeAlterIndex represents index recommendation ALTER INDEX...VISIBLE.

TypeCreateIndex represents index recommendation CREATE INDEX.

TypeReplaceIndex represents index recommendation CREATE INDEX followed by DROP INDEX.

HypotheticalTable is a wrapper around cat.Table, used for creating index recommendations.

Rec represents an index recommendation in the form of a SQL statement(s) that can be executed to apply the recommendation.

Type represents the type of index recommendation for Rec.