Relative ratio of CPU speed

This value indicates the ratio between the CPU speed of the federated server and the CPU speed of the server on which the remote data source is located.

This value is defined as the CPU speed of the federated server divided by the CPU speed of the server for the remote data source. For example, if the CPU speed for the federated server is twice as fast as the CPU speed for the remote server, then CPU_RATIO should be set to 2. If the CPU speed for the federated server is only one third as fast as the CPU speed for the remote server, then CPU_RATIO should be set to 0.33.

When you do not set the CPU ratio server option explicitly, the federated optimizer uses a default value of 1, which indicates that the federated CPU speed and the data source CPU speed are equal.

A low ratio indicates that the data source server CPU is faster than the federated server CPU. For low ratios, the optimizer will consider pushing-down operations that are CPU-intensive to the data source. A low ratio is a value that is less than 1.