Re: Materialized View - Performance
Date: Wed, 3 Dec 2008 22:28:11 -0800 (PST)
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.
Raja. Received on Thu Dec 04 2008 - 00:28:11 CST