Return
-
Title
How to set the optimizer to “Always” put out ANSI standard SQL? -
Description
How to set the optimizer to “Always” put out ANSI standard SQL?
-
Resolution
To put the alternative to ANSI standard, you may change it in Option window.
Option | Optimizer | Intelligence
Select the ‘Custom Settings’
And than go
Option | Optimizer | Optimization
In the ‘Join Tables’ section, select ‘Rewrite SQL using the ANSI-92 JOIN syntax’.