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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.