Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view + explain plan (Oracle 9.2.2)
icon9.gif  Materialized view + explain plan [message #324992] Wed, 04 June 2008 13:13 Go to next message
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.



Re: Materialized view + explain plan [message #325111 is a reply to message #324992] Thu, 05 June 2008 01:06 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
did you run the explain plan for a select query on the Materialized view, or the actual sql query of the view (which selects from base tables) ?

Regards
Minto
Re: Materialized view + explain plan [message #325589 is a reply to message #325111] Fri, 06 June 2008 11:01 Go to previous message
riki
Messages: 12
Registered: April 2008
Location: ny
Junior Member


The query is run on Base table only.
Previous Topic: use of sequence
Next Topic: PAssing table and column names as parameters
Goto Forum:
  


Current Time: Sun Dec 04 21:01:25 CST 2016

Total time taken to generate the page: 0.10203 seconds