Cost model

The Adaptive Server optimizer computes the cost of a clustered index partition scan differently, depending on the total number of pages that need to be scanned:

The actual cost of the scan may be higher if:

If both of these conditions are true, the actual cost of the scan is the same as if the scan were executed serially.