|< < 18 > >|

Combining operators

It is often possible to improve overall performance by anticipating how an operator's output will be used.

`Sort`, `Project`, and `Unique`

Query


select distinct a, b, c
from ...
order by a, b, c

Execution Plan


Unique(
    Project(
        Sort(..., [a, b, c]),
    [a, b, c]))

|< < 18 > >|