November 19, 2018

View and Materialized View

standard view means SQLs, it’s composed by SQLs join some tables or function calls, etc, it hides low level implements, just give you a composed model, but if you have a large data set view, it could slow down your database performance as it should execute SQLs when you query it.

materialized view records result until you refresh it, so it’s better for cache, performance.

Powered by Hugo & Kiss.