Link to home
Start Free TrialLog in
Avatar of daniesh
daniesh

asked on

what is materilaized views?

Hi Experts,
what is materialized views?
how its helps in database performance?why we refresh it?

could you please help me the concept of materialized view?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

>what is materialized views?
is a kind of view, but storing the results like a table. based on the refresh parameters, the data can be updated automatically behind, either fully or with transactional update.

>how its helps in database performance?
materialized views can reduce I/O on the queries (check out query rewrite), doing pre-aggregation.

>why we refresh it?
because the underlying data changes, and unlike a traditional view, the underlying data is not queried, but the stored data.
Avatar of daniesh
daniesh

ASKER

but view can also store the result like a table if we update any table if we have created a views on it then the changes will reflect in the view.
please explain the below statement in more details

materialized views can reduce I/O on the queries (check out query rewrite), doing pre-aggregation.

Avatar of daniesh

ASKER

could you please explain me the basic difference between views and materialized view.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh

ASKER

thanks ..
could you please tell me the difference between view and materialized view.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh

ASKER

thanks for your help.
Avatar of daniesh

ASKER

I think one more difference is that we can refresh materialized view and we cant normal view.

one more we can create view only for a particular session.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh

ASKER

thanks a lot...