Re: Materialized View - Performance

From: raja <>
Date: Wed, 3 Dec 2008 22:28:11 -0800 (PST)
Message-ID: <>


I am just exploring the ways to tune a MV. I have a MV which is a union of data from 2 tables ( no where conditions), so its going for full table scan for both the tables. I want to know whether we can use the following in MV : 1. Hints - can we use hints like fast full scan,..... 2. With Clause - since in another MV, looks like a query is getting repeated more than once.

With Regards,
Raja. Received on Thu Dec 04 2008 - 00:28:11 CST

Original text of this message