Re: Materialized View - Performance
From: raja <dextersunil_at_gmail.com>
Date: Wed, 3 Dec 2008 22:28:11 -0800 (PST)
Message-ID: <10566b28-385f-4413-84a8-7a10a5c626b5@p2g2000prn.googlegroups.com>
Date: Wed, 3 Dec 2008 22:28:11 -0800 (PST)
Message-ID: <10566b28-385f-4413-84a8-7a10a5c626b5@p2g2000prn.googlegroups.com>
Hi,
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