Logical Query Plan in VertiPaq


Common logical query plan operators

Operator Description
AddColumns Adds columns to a table.
Calculate Calculates a scalar expression by applying specific filters. It corresponds to the CALCULATE function in DAX.
CalculateTable Calculates table expression by applying specific filters. It corresponds to the CALCULATETABLE function in DAX.
Filter_VertiPaq Returns a table usually applied as a filter to a Calculate operator.
GroupBy_VertiPaq Performs group by of the table using the specified columns.
GroupSemiJoin Joins the result of two operators, returning all the rows in the first table if there is a match with the result of the second operator.
ScalarVarProxy Returns e value of a scalar variable computed inside a variable scope introduced with the VarScope operator.
Scan_Vertipaq Performs the scan of a table using the VertiPaq storage engine.
Sum_Vertipaq Performs SUM aggregation using the VertiPaq storage engine. Similar operators are available for MIN, MAX, and COUNT aggregations.
TableVarProxy Returns the value of a table variable computed inside a variable scope introduced with the VarScope operator.
VarScope Opens variable scope. It contains a list of variable definitions defined with the VarName property. The result of the VarScope operator is the last operator in the scope.
Last update: Oct 13, 2024