Materialized view + explain plan [message #324992] |
Wed, 04 June 2008 13:13  |
riki
Messages: 12 Registered: April 2008 Location: ny
|
Junior Member |
|
|
Hello All,
I have a set of queries which perform aggregate operations on a single table .The performance of the query(s) is very bad and no other option has worked .
So I have created a materialized view on the table.
Till now its fine but
The problem is when I execute the query and run the explain plan on it the MV is not getting picked up.
There is a FULL TABLE SCAN going on.
I have tried the MV with REFRESH ON COMMIT and REFRESH ON DEMAND and other options as well.Nothing works.
Any suggestions on what to be done .....
Am not posting the actual query am using I can fwd the details if needed.
Thanks and Regards,
riki.
|
|
|
|
|