Further to this, and assuming that I should see the same "culprits" in table and index CRUD within the top ten of each, I have an issue that I think I haven't reported before. In this case, the number two table ("vendor") in reads (Raw/Summary) doesn't show up in PT. Here is PT data and my data:
Tbl# Area# Table Name RM Chain #Records Frag% Scat Turns AvgRow Create Read v Update Delete OS Read
āāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāā
274 7 sd-joint 502 29666 0.00% 1 1067.01 42 0 31653874 0 0 246
277 11 sd-payt 250412 44931896 0.22% 1 0.01 189 227 306531 886 0 5379
-2 6 _Field 10318 76.55% 6 16.33 315 0 168536 0 0 0
85 7 corp-individ 409 109744 52.71% 1 1.03 289 0 113334 0 0 4012
271 7 sd-cash-drawer 508 733 0.00% 1 52.01 117 0 38121 254 0 23
282 15 sd-teller-tran 336 19871693 0.00% 1 0.00 108 20 34233 0 0 20767
284 7 sd-xact 503 572 0.00% 1 54.48 84 0 31161 0 0 7
270 7 sd-acct-xact 507 8382 0.00% 1 3.54 50 0 29714 0 0 18
201 7 occup 507 164 0.00% 1 140.01 33 0 22961 0 0 2
-1 6 _File 688 92.30% 5 30.25 450 0 20810 0 0 0
Table Table name Reads Reads/sec O/S Reads Hit % Creates Updates Deletes
āāāāā āāāāāāāāāāāāāāāāāāāāāāāāāāāāāāāā āāāāāāāāāāāāāā āāāāāāāāāāāāāā āāāāāāāāāāāāāā āāāāāāā āāāāāāāāāā āāāāāāāāāā āāāāāāāāāā
274 sd-joint 31,653,874 3,521 246 99.999 0
338 vendor 1,209,643 135 51 99.996 0
277 sd-payt 306,531 34 5,379 98.245 227 886
-2 _Field 168,536 19 100.000 0
85 corp-individ 113,334 13 4,012 96.460 0
271 sd-cash-drawer 38,121 4 23 99.940 254
282 sd-teller-tran 34,233 4 20,767 39.336 20 0
284 sd-xact 31,161 3 7 99.978 0
270 sd-acct-xact 29,714 3 18 99.939 0
201 occup 22,961 3 2 99.991 0
-1 _File 21,641 2 100.000 0