Compiled SQL Statement (Source Dataset)

Allow compiled SQL statement for the original set.

Values

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.