C
ChUIMonster
Guest
"Next to no difference" measured how? The ratio of logical reads to record reads? Or some flaky timing comparison? The difference in runtime going from from a 3.5: 1 to a 2:1 ratio when we are only talking about 10,000 record reads is going to be minuscule. Either way it is a small fraction of a second. If this is all about making a query like that go noticeably faster you're probably barking up the wrong tree anyway. If you have some bit of code reading roughly 10,000 records and it is taking more than a fraction of a second the problem isn't that the ratio of logical reads to record reads is slightly higher than ideal -- the problem lies elsewhere.
Continue reading...
Continue reading...