Re: Materialized view vs. view

Le 10/33/2017 à 21:33, David G. Johnston écrivait :
> On Tue, Jan 10, 2017 at 1:01 PM, Melvin Davidson
> <[1]melvin6925(at)gmail(dot)com> wrote:
>
> Can we all agree that the "Materialized View" should be faster
> ​
>
Yes.
The OP told about a 500K rows view. Every select queries on that view will
have to fetch those 500K rows before - in any case this is quite slow.
However, 500K rows do not represent a huge physical space to
materialize. But do not forget to index/refresh the materialized views,
depending on the select set of queries to run.

Answer would have been different with 50K rows I guess.

>
> If you add in the condition that the same answer has to be returned
> whether you query the view or the mat-view then no, I wouldn't agree;
> and the original question is, IMO, unanswerable (or at least, if
> answered, requires making assumptions that tend to go unstated).
>
> is just an opinion and too late to change at this point?
>
> Your opinion, or the name? :)
> ​David J.​
>
> References
>
> 1. mailto:melvin6925(at)gmail(dot)com