Thanks to eva one for clearing out my db concepts.
On Jul 20, 3:02 am, ddf wrote:
> Comments embedded.
>
> On Jul 18, 1:11 am, weird0 wrote:
>
> > I would like to know what is the difference between a View and
> > Materialized View?
>
> > As far as my knowledge goes, view holds the result of se
Comments embedded.
On Jul 18, 1:11 am, weird0 wrote:
> I would like to know what is the difference between a View and
> Materialized View?
>
> As far as my knowledge goes, view holds the result of select query
> from tables.
Incorrect. 'Regular' views store no data.
> It makes the application
It is Materialized view which may make application faster (performance may
improve , but not necessariy)
Views when refrenced, Run in real time and execute the queries against the
original table, so the performance may be same as original query
Materialized view , when runs for the first time, Ex
On Jul 18, 2:11 am, weird0 wrote:
> I would like to know what is the difference between a View and
> Materialized View?
>
> As far as my knowledge goes, view holds the result of select query
> from tables. It makes the application faster because the result-set is
> not calculated at run-time.
>
>
I would like to know what is the difference between a View and
Materialized View?
As far as my knowledge goes, view holds the result of select query
from tables. It makes the application faster because the result-set is
not calculated at run-time.
Mview is set to be refreshed on some basis i.e.
