The Importance of Index Only Scans in MVC

"I rarely see, I see it, but not frequently at all, that people try to minimize the number of indexes," says MVC expert. "Before even considering index only scans, probably we should think about more fundamental problems like blowout and data loss", he adds. 'The second item you mentioned, it's probably the most interesting one to reach index only scan run faster due to heap fetches zero'

Transcript

Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.