Log in to continue
We're a place where coders share, stay up-to-date and grow their careers.
DEV is a community of 461,028 amazing developers
We're a place where coders share, stay up-to-date and grow their careers.
We're a place where coders share, stay up-to-date and grow their careers.
re: Centralize Your Query Logic! VIEW POST
TOP OF THREAD FULL DISCUSSIONThis isn't an innate benefit of using (regular, non-materialized) views. As far as I know any performance benefit would be from the improved query consistency making it easier to hit the cache instead of having to read from disk.
Resurrecting an old discussion, but I find that many people actually mean "materialized view" when they say "view", because the only time they use them is to get over some performance bottleneck.