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