SET OPTIMIZATION may be used to turn on or off internal engine optimizations. This is usually only required when attempting to diagnose why a particular query has an error. Turning off the optimizer will cause a very literal execution of the SQL code and can help point out problems in the query optimizer.

Gibraltar Support may ask you to turn off optimizations and try your query again as a workaround.

SET OPTIMIZATION { ON | OFF };

Example

SET OPTIMIZATION OFF;