AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
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'