<< Click to Display Table of Contents >>
Compiled SQL Statement
Allow compiled SQL for the original set
Values
True |
Allow |
False |
Not allow |
Reference
Using the compiled SQL improves SQL performance, when repeating the same SQL. Usage of the compiled SQL depends on the database vendors (JDBC database provides preparedstatement).
This feature works only when executing the SQL on the server. When Query Designer executes the SQL, even though set to True, the SQL is executed as non-compiled SQL.
See Also