Databases Reference
In-Depth Information
Number of times some
hint was specified. Hints
counted include:
JOIN
,
GROUP
,
UNION
and
FORCE
ORDER
query hints,
FORCE
PLAN
set option, and
join hints.
hints
Not applicable.
Number of times a force
order hint was specified.
order hint
Not applicable.
Number of times the join
algorithm was forced by a
join hint.
join hint
Not applicable.
Number of times a view has
been referenced in a query.
view reference
Not applicable.
Number of optimizations
where the query referenced
at least one remote data
source, such as a table with
a four-part name or an
OPENROWSET
result.
remote query
Not applicable.
Average effective
MAXDOP
value for an
optimized plan. By default, effective
MAXDOP
is determined by the max degree of parallelism
server configuration option, and may be
overridden for a specific query by the value
of the
MAXDOP
query hint.
Total number of
optimizations.
maximum DOP