Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SQL_PARTOPEN_COST

SQL_PARTOPEN_COST <multiplier>

Adjusts the partition file open cost optimization.

A partitioned file open cost is available for the SQL cost analyzer such that SQL takes into account the cost of opening partitions. Costs are calculated as follows:

  • For an index on a partitioned file that is the partition key, the original table open cost is reported.
  • For an index on a partitioned file that is not related to the partition key, the original table cost plus a multiplier times the number of active partitions is reported.
  • For an index on a partitioned file that covers the partition key but does not order like the partition key, the original table cost plus a multiplier times the number of active partitions divided by 2 is reported.

Default: 10000

TOCIndex