4 ms·
What's the difference between that and a non sql approach? Writing a program that makes a temporary table somewhere, and if there's a mistake you have to start
by jbverschoor 8y ago
What's the difference between that and a non sql approach?
Writing a program that makes a temporary table somewhere, and if there's a mistake you have to start all over again?
- magicalhippo 8y agoWell, for immediate refresh materialized views, how do you keep your non-sql solution up to date? For manual refresh, I agree, either non-sql or just plain temp tables is a decent alternative. In our case the views do a lot of joins and subqueries, so we've mostly used temp tables.