Databases Reference
In-Depth Information
Number of optimizations
in which a
MAXRECUR-
SION
level greater than 0
has been specified with the
query hint.
Average
MAXRECURSION
level in optimizations
where a maximum recursion level is specified
with the query hint.
maximum
recursion level
Number of queries for which
one or more indexed views
were loaded for consideration
for matching.
indexed views
loaded
Average number of views loaded.
Number of optimizations
where one or more indexed
views have been matched.
indexed views
matched
Average number of views matched.
Number of optimizations
where one or more indexed
views are used in the output
plan after being matched.
indexed views
used
Average number of views used.
Number of optimizations
of a DML statement that
produce a plan which
maintains one or more
indexed views.
indexed views
updated
Average number of views maintained.
Number of optimizations
in which a dynamic cursor
request has been specified.
dynamic cursor
request
Not applicable.
Number of optimizations in
which a fast-forward cursor
request has been specified.
fast-forward
cursor request
Not applicable.
Table 5-2:
Books Online documentation, with undocumented counters.
