| Re: About Materialized Views [message #75108] |
Thu, 30 August 2001 17:06 |
Deepak Rai
Messages: 2
Registered: August 2001
|
Junior Member |
|
|
Hi Lulu,
First of all your conecpt about refershing MV first time manually is wrong.
Their are different type of m view.
if you mv doesn't have any summary column (means Group by columns) ,then you can create MV with refersh option on commit,then you don't need to refresh.MV is not just like a table,you can understand in some other way-
if your query redirect is true in init.ora file and you passed a query on base table ,if the data is available in MV then it will give result from MV,but if your query range data is not available in mV ,it will pass query on base table and show the result from base table.
materilized view always based on a base table.
if you see by passing the query (select * from tab),it will show you as table.
for refereshing ,so many option is their..
if you want manual refersh then use dbms_mview.refresh (3 more option in this package).If you are working in a Datawarehousing application or any working where reports are required on frequently basis ,MV is the best Choice.
for more information about MV pl. go thru Oracle Documentation.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
