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. |
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...