DEV Community

Discussion on: Centralize Your Query Logic!

dmfay profile image
Dian Fay Author

This 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.

citizen428 profile image
Michael Kohl

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.