Condition skipped. Table '
table_name
' column '
column_name
has a GE/GT,LE/LT condition on a low-ended machine.
When PowerExchange executed SQL with a WHERE clause against data for KSDS, the NRDB optimized reading process discarded a condition. The condition is still used for post-read qualification. PowerExchange cannot produce limit low and high values for integer fields on low-ended machines such as Linux and Windows.
Processing continues, but the skipped condition causes too many records to be read, which causes slower overall processing.
If possible, construct the SQL WHERE clause condition using comparisons on fields that are used in a database key. Keys on low-ended machines do not typically contain integer fields. This message can be suppressed using the REPORT_UNUSED_OPT_READING_CONDITIONS=N parameter.