Home » Server Options » Replication » Help on Materialized views
Help on Materialized views [message #75377] Thu, 03 July 2003 03:58
Sudha
Messages: 29
Registered: November 2000
Junior Member
I have created a materialized view by joining some 4 tables. I want to check that, if i write a query by joining the same 4 tables(with the columns used in the MView), will my query give the result from the materialized view? I have set the Query_Rewrite to true. Are there any sys tables or views where the result of the execution is stored?

Report message to a moderator

Previous Topic: refreshing snapshot with unique index
Next Topic: BLOB to LONG RAW Conversion ?!?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 11:56:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.