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?
Previous Topic: refreshing snapshot with unique index
Next Topic: BLOB to LONG RAW Conversion ?!?
Goto Forum:
  


Current Time: Thu Mar 28 08:04:22 CDT 2024