Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Materialized Views: sometime used/ sometime not....

Status
Not open for further replies.
goyalpdm

goyalpdm

Programmer
Jan 11, 2003
42
US
Does someone has experience with Materialized Views?

I am new to this and have created such views for some queries (response time > 60 sec). Issue is: MV works well right after it is created and we get very good response time (< 10 sec). But if query is performed after sometime (say ~3 hrs later) it goes back to bad performance.

MV has been created with ENABLE QUERY REWRITE option.

Appreciate any help.
 
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving &quot;all&quot; records suddenly
Replies
3
Views
361
carp
carp
Rasheed Shaik
  • Locked
  • Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
461
Rasheed Shaik
Rasheed Shaik
sirnose1
  • Locked
  • Question
Filter by SysDate not working
Replies
3
Views
136
Andrzejek
Andrzejek
fayevalentine
  • Locked
  • Question
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified
Replies
3
Views
159
fayevalentine
fayevalentine
sw1202
  • Locked
  • Question
can not run oracle form on 64 bit window 10 machine
Replies
4
Views
141
sw1202
sw1202

Part and Inventory Search

Sponsor

Back
Top