Simplifies boolean expressions where the answer can be determined without evaluating both sides.
Attempts to eliminate the reading of unneeded columns from the query plan using the following transformations:
Combines two adjacent Filter operators into one, merging the conditions into one conjunctive predicate.
Combines two adjacent Limit operators into one, merging the expressions into one single expression.
Replaces Expressions that can be statically evaluated with equivalent Literal values.
Replaces Expressions that can be statically evaluated with equivalent Literal values.
Pushes down Filter operators where the condition
can be
evaluated using only the attributes of the left or right side of a join.
Pushes Filter operators through Project operators, in-lining any Aliases that were defined in the projection.
Removes the inner CaseConversionExpression that are unnecessary because the inner conversion is overwritten by the outer one.
Removes Casts that are unnecessary because the input is already the correct type.
Removes filters that can be evaluated trivially.