Option | Syntax | Description | Example |
DISABLE_PUSH | DISABLE_PUSH causes the query engine to process the GROUP BY operator locally in TDV Server, instead of pushing it to the data source. If DISABLE_PUSH is not specified, the GROUP BY operator is pushed to the data source whenever possible. | SELECT MAX(column2) FROM table1 GROUP BY {OPTION DISABLE_PUSH} column1 |
DISABLE_THREADS | DISABLE_THREADS prevents the query engine from using background threads to speed up processing of the GROUP BY operator. You can use this option to prevent queries from using excessive server resources. If DISABLE_THREADS is not specified, the query engine always uses background threads to speed up processing. This GROUP BY option takes precedence over the SELECT-level DISABLE_THREADS option. | SELECT MAX(column2) FROM table1 GROUP BY {OPTION DISABLE_THREADS} column1 |
FORCE_DISK | FORCE_DISK causes the query engine to use disk instead of memory for temporary storage of data that is required to process the GROUP BY operator. This frees up memory for other server operations. FORCE_DISK is particularly useful for queries that consume a large amount of memory. If FORCE_DISK is not specified, the query engine uses memory instead of disk, whenever possible, for maximum performance. This GROUP BY option takes precedence over the SELECT-level option of the same name. | SELECT MAX(column2) FROM table1 GROUP BY {OPTION FORCE_DISK} column1 |