You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/t-sql/queries/hints-transact-sql-query.md
+6-2Lines changed: 6 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -86,7 +86,8 @@ Query hints specify that the indicated hints should be used throughout the query
86
86
| EXPAND VIEWS
87
87
| FAST number_rows
88
88
| FORCE ORDER
89
-
| { FORCE | DISABLE } EXTERNALPUSHDOWN
89
+
| { FORCE | DISABLE } EXTERNALPUSHDOWN
90
+
| { FORCE | DISABLE } SCALEOUTEXECUTION
90
91
| IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX
91
92
| KEEP PLAN
92
93
| KEEPFIXED PLAN
@@ -162,7 +163,10 @@ Specifies that the join order indicated by the query syntax is preserved during
162
163
163
164
{ FORCE | DISABLE } EXTERNALPUSHDOWN
164
165
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
+
166
170
KEEP PLAN
167
171
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:
0 commit comments