Skip to content

Commit a73a3b4

Browse files
authored
Update hints-transact-sql-query.md
{ FORCE | DISABLE } SCALEOUTEXECUTION Query hint was added for SQL 2019 Big Data Clusters around the CTP 2.3 timeframe, but was never documented. Added this hint to the document
1 parent 7868b7d commit a73a3b4

1 file changed

Lines changed: 6 additions & 2 deletions

File tree

docs/t-sql/queries/hints-transact-sql-query.md

Lines changed: 6 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -86,7 +86,8 @@ Query hints specify that the indicated hints should be used throughout the query
8686
| EXPAND VIEWS
8787
| FAST number_rows
8888
| FORCE ORDER
89-
| { FORCE | DISABLE } EXTERNALPUSHDOWN
89+
| { FORCE | DISABLE } EXTERNALPUSHDOWN
90+
| { FORCE | DISABLE } SCALEOUTEXECUTION
9091
| IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX
9192
| KEEP PLAN
9293
| KEEPFIXED PLAN
@@ -162,7 +163,10 @@ Specifies that the join order indicated by the query syntax is preserved during
162163
163164
{ FORCE | DISABLE } EXTERNALPUSHDOWN
164165
Force or disable the pushdown of the computation of qualifying expressions in Hadoop. Only applies to queries using PolyBase. Won't push down to Azure storage.
165-
166+
167+
{ FORCE | DISABLE } SCALEOUTEXECUTION
168+
Force or disable scale out execution of PolyBase queries that are using External tables in a SQL Server 2019 Big Data Cluster. This hint will only be honored by a query using the master instance of a SQL Big Data Cluster. The scale out will occur across the Compute Pool of the Big Data cluster.
169+
166170
KEEP PLAN
167171
Forces the Query Optimizer to relax the estimated recompile threshold for a query. The estimated recompile threshold starts an automatic recompile for the query when the estimated number of indexed column changes have been made to a table by running one of the following statements:
168172

0 commit comments

Comments
 (0)