Precedence for distribution of work by object

The following list shows how the High-speed Apply Engine resolves conflicts between different types of distribution by an object (when you define more than one type in your configuration).

Related topic

DistributionTuning-parameters

A type of distribution higher on this list takes precedence over a type that is lower on the list:

  • User-defined groups of tables (defined by [ObjectCluster] parameters)
  • Groups of tables defined by RI relationships (when RIClustering is Yes)
  • User-defined partitions (defined by [ObjectPartition] parameters)
  • Partitions defined by partitioned table spaces (when PartitionClustering is No)
  • Groups of tables defined by simple table spaces (when SimpleTSClustering is No)
  • Individual tables

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*