4 ms·
"Incremental view maintenance" Lots and lots of theory about how to do this correctly. I authored a project to do this with triggers. https://github.com/rivet
by paulddraper 3y ago
"Incremental view maintenance"
Lots and lots of theory about how to do this correctly.
I authored a project to do this with triggers. https://github.com/rivethealth/denorm https://github.com/rivethealth/denorm
- jjgreen 3y agoNice! I did this "by hand" for a dozen views a few years back, fiddly but rewarding; if I have to do it again ...