FORCE_ESTIMATION (SELECT Option)
FORCE_ESTIMATION is used to control the level of statistics estimation to be performed on the query execution plan. Possible values are “-1” (default value that indicates no estimation), "1" (estimation done on each plan operator at the row level) and “2” (estimation done on each plan operator at the column level).
The default value (-1) can be overridden by specifying a different default value in the server configuration setting “Default SQL Options”. In TDV Studio, go to Administration -> Configuration -> Server -> SQL Engine -> Default SQL Options and add a key-value pair for the FORCE_ESTIMATION option. Setting the option here can affect all SQL statements and therefore should be used with care.
Operator
SELECT
Syntax
force_estimation
Example
SELECT {OPTION force_ESTIMATION} *
FROM table1 INNER JOIN table2 ON table1.id = table2.id
INNER JOIN table3 ON table1.id = table3.id