Multiple choice technology databases

How will you see logical reads for a query when executing it.

  1. SET XMLSTATS IO ON

  2. SET STATISTICS TIME ON

  3. SET STATISTICS I/O ON

  4. SET STATISTICS IO ON
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Executing SET STATISTICS IO ON in SQL Server displays information about disk activity, including logical reads, physical reads, and read-ahead reads generated by statements. The command SET STATISTICS TIME ON displays CPU and elapsed time, while SET STATISTICS I/O ON containing a slash is syntactically invalid.

Keep practicing — related questions