Fast Tuning Logic
CONNX Fast Tuning Logic (FTL) automatically simplifies WHERE clause expressions used in SQL queries by eliminating elements deemed unnecessary to producing query results or by producing a more efficient expression that creates identical results. For example, for the following SQL statement:
SELECT * FROM customers_dataflex
WHERE (((customers_dataflex.CUSTOMERCITY)='Seattle')
AND ((customers_dataflex.CUSTOMERSTATE)='WA'))
OR (((customers_dataflex.CUSTOMERCITY)="Bellevue")
AND ((customers_dataflex.CUSTOMERSTATE)="WA"))
CONNX FTL is able to produce this simplified SQL statement:
SELECT * FROM Customers_dataflex t1
WHERE ( t1.CUSTOMERSTATE ) = 'WA'
AND
( ( t1.CUSTOMERCITY ) = 'Bellevue'
OR
( t1.CUSTOMERCITY ) = 'Seattle' )
You can prevent CONNX for performing this optimization. To do so, alter the query by adding the {nosqloptimize} tag at the end of the SQL statement. The function tag forces the query to process exactly as written.