Set DirectDistinctSupport Parameters for the Loading script
You can do asynchronous, parallel calls to the database by using the connection pooling capability. The load script syntax to set up the pooling capability is as follows:
When a DIMENSION field value is selected in a QlikView object, a query is generated for the source database. SetDirectDistinctSupport to 'false' to generate GROUP BY instead of DISTINCT in queries for unique values.
In high cardinality multi-table scenarios, it is possible to generate subqueries in the SQL query instead of generating a large IN clause. This is activated by settingDirectEnableSubqueryto'true'.
Note: When DirectEnableSubquery is enabled, you cannot load tables that are not inDirect Discovery mode.