Hacker News new | ask | show | jobs
by gfody 1944 days ago
if sql server can't incrementally maintain your view then it doesn't let you index it. that's why there are so many restrictions but on the flip side if you manage to workaround the restrictions then decent update performance is assured.