Function DefaultRules

pkg/advisor/rules.go:25–50

DefaultRules returns the default set of all built-in optimization rules.

()

// DefaultRules returns the default set of all built-in optimization rules.
func DefaultRules() []Rule {
	return []Rule{
		// OPT-001 through OPT-008: original rules
		&SelectStarRule{},
		&MissingWhereRule{},
		&CartesianProductRule{},
		&DistinctOveruseRule{},
		&SubqueryInWhereRule{},
		&OrInWhereRule{},
		&LeadingWildcardLikeRule{},
		&FunctionOnColumnRule{},
		// OPT-009 through OPT-020: advanced rules
		&CorrelatedSubqueryInSelectRule{},
		&HavingWithoutGroupByRule{},
		&RedundantOrderByInCTERule{},
		&ImplicitTypeConversionRule{},
		&OrToInConversionRule{},
		&NotInSubqueryNullRule{},
		&MissingLimitRule{},
		&UnusedAliasRule{},
		&UnionDeduplicationRule{},
		&CountStarRule{},
		&DeepSubqueryNestingRule{},
		&ExplicitCrossJoinRule{},
	}
}

// ---------------------------------------------------------------------------
// OPT-001: SELECT * Detection