Home » RDBMS Server » Performance Tuning » materialized view
materialized view [message #109067] Mon, 21 February 2005 13:38 Go to next message
Rao Ghanta
Messages: 1
Registered: February 2005
Junior Member
Hello,

I have a problem when i create a materialized view . When i ran a sql it is taking 40 min for fetching 152180 rows from the table. When i build materialized view it is taking almost 3 hours to build the view. Please help me.

This is the query i am running..
create materialized view GHANTA_TEST_TIME_MVW
build immediate
refresh COMPLETE START WITH SYSDATE NEXT trunc(SYSDATE+1) + 1/5
enable query rewrite
as
select * from GHANTA_TEST_TIME_VW

Thanx in Advance.
Re: materialized view [message #109310 is a reply to message #109067] Wed, 23 February 2005 13:06 Go to previous message
Mack Sundar
Messages: 20
Registered: July 2002
Junior Member
Also, keep in mind that materialized views are physically storing the data on disk. Therefore, might help to check if you have any disk contentions.
Previous Topic: Invalid Object in sys schema
Next Topic: RAW datatype with NUMBER
Goto Forum:
  


Current Time: Thu Mar 28 12:23:52 CDT 2024