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.
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.
Log in to continue
We're a place where coders share, stay up-to-date and grow their careers.
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.
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.