User guide

Data Integration with Sybase Avaki Studio 159
Order By
Order By
The Order By operator sorts its input based on the criteria you specify. Order By
does not affect the result set’s schema or the number of rows it contains.
Connections
The Order By operator takes exactly one input result set, which can be the output of
an Input Source or of any other operator. It produces exactly one output result set
whose schema is the same as the input.
Performance notes
Avaki Studio uses an O(n log n) algorithm for performing all its sorting operations.
This algorithm writes temporary data to disk if the result set to be sorted is too large to
fit into memory; thus it scales to accommodate arbitrarily large result sets.
When operators in your model sort their data, Studio remembers which columns the
data was sorted by and passes that information along. This way, operators that need
sorted data don’t have to re-sort data unnecessarily. This can dramatically increase the
performance of Studio-generated data services.
Required Connection