Used when pseudo optimal column ordering is active. Specifies the subpartition size for column ordering.
Syntax
OPTIMIZE_SUMMATION_ORDER_PARTITION=value;
Notes
The bigger the value of OPTIMIZE_SUMMATION_ORDER_PARTITION the better savings will be attained, however the time needed for initial column ordering depends quadratically on OPTIMIZE_SUMMATION_ORDER_PARTITION. Default is 750.
Examples
Last modified: 9/5/2002
Sergei L. Kosakovsky Pond and Spencer V. Muse, 1997-2002