Another cool feature of Views is better performance compared to normal queries with multiple join statements especially in high traffic websites with a lot of records, or so I’ve heard from more senior devs, correct me if I’m wrong
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.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.