The max scan parallel degree configuration parameter is used only for backward compatibility, when the data in a partitioned table or index is highly skewed. If the value of this parameter is greater than 1, Adaptive Server uses this value to do a hash-based scan. The value of max scan parallel degree cannot exceed the value of max parallel degree.
