Optimizing SQL Database Performance

Optimizing Database Performance


The Collapse logical and physical operator optimizes update processing. When an update is performed, it can be split (using the Split operator) into a delete and an insert. If the Argument column contains a GROUP BY:() predicate and a list of key columns being grouped, the query processor groups by the set of key columns to optimize these update operations by removing any temporary, unnecessary intermediate changes to each row.

See Also