Statistics

$=MCQ$

DESCRIPTION

When checking the index usage statistics information, retrieved by querying the sys$.$dm$\_$db$\_$index$\_$usage$\_$stats dynamic management view, explain the results of the returned number of seeks?

Answer choices

Please choose a correct answer:

OUNSOIVED

It shows the number of times the leaf pages of the index are scanned,

It indicates the number of times the index is used to find a specific row,

It indicates the number of times a Clustered index is used by the Non$-$clu: $x$ to fetch the full row.

It shows the number of times the index data has modified.

Powered by DoSelect

$15C$

Partly cloudy

Search