Description


From a performance point of view it is preferrable to use a single IN clause instead of many ORs against RDBMS like Oracle or SQL Server.

Use Case


Uniface as of 9.7.02 in its QueryByForm functionality always build many ORs when GOLD| and GOLD; are used. This behaviour should be improved. Documentation coming from RDBMS like Oracle or SQLserver reports SQL parser and optimizer could use available indexes with a single IN while is definitively NOT considering to use indexes when multiple ORs are defined into a SQL instruction.

Importance


medium

Type


Database Drivers

Operating System


Not Applicable

Status


Open

One thought on “Use IN instead of ORs to RDBMS”

Leave a Reply