How can DiskRead be smaller than DiskReadTable?

1

When comparing Graphical Plans With Statistics in V17, should the "DiskRead" statistic be completely ignored as some archaic fiction, in favor of "DiskReadTable" and the like?

Here's an example:

ProductVersion 17.0.10.6089
DiskRead       63 Disk reads       The number of pages that have been read from disk 
DiskReadTable 368 Disk table reads The number of table pages that have been read from disk

...or maybe it doesn't matter much, as long as "Xxx"s are compared with "Xxx"s, when comparing query performance?

In other words, performance statistics are valuable for comparison purposes, NOT exact measurement or metering purposes.

asked 11 Apr '21, 10:51

Breck%20Carter's gravatar image

Breck Carter
32.5k●541●724●1050
accept rate: 20%

edited 11 Apr '21, 10:54

1

May I bump this question up in this forum? I am curious, how these values are measured? E.g. is "DiskRead" related to indexes as well, and tables reads are just for tables...

(17 Apr '21, 16:57) Vlad
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×1

question asked: 11 Apr '21, 10:51

question was seen: 437 times

last updated: 17 Apr '21, 16:57

Related questions