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
I agree, we have the same issues over here.
We did some limitations in the software so we don’t get a very long OR list.