Optimizing SQL Database Performance

Optimizing Database Performance


The Parallelism physical operator performs the Distribute Streams, Gather Streams, and Repartition Streams logical operations. The Argument columns can contain a PARTITION COLUMNS:() predicate with a comma-separated list of the columns being partitioned. The Argument columns can also contain an ORDER BY:() predicate with a list of the columns for which the sort order is preserved during partitioning.

See Also

Distribute Streams

Repartition Streams

Gather Streams