Local and Remote Query Performance
If you have identical local and remote VSAM KSDS files, an SQL query should execute faster when ran against the local file.
CONNX SQL query performance against remote VSAM KSDS files can be optimized by importing index information from corresponding local files, if available. Once the key information is provided for remote files, CONNX executes the same file traversal logic for both local and remote files. The remaining differences in performance measures such as records per second derive from the MRO or ISC link overhead between the CICS regions.