Database Reference
In-Depth Information
Figure 34-4.
Row-mode processing
Alternatively, with batch-mode processing, the
Filter
operator would set an internal bitmap that shows the
validity of the rows. A subsequent
Aggregate
operator would process the same batch of rows, ignoring non-valid ones.
No data copying is involved. Figure
34-5
shows such an approach. It is also worth noting that only the
ArticleId
,
Quantity
, and
UnitPrice
columns would be loaded into the batch.
Figure 34-5.
Batch-mode processing
■
In a real system, sQL server can push a predicate that evaluates if
UnitPrice >=10
to the
Columnstore Index
Scan
operator, preventing unnecessary rows from being loaded into the batch. However, let's assume that it is not the
case in our example.
Note