Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view or Temporary Table
icon1.gif  Materialized view or Temporary Table [message #219103] Mon, 12 February 2007 23:40 Go to next message
sruthi
Messages: 23
Registered: May 2006
Junior Member
Hi all,

I'm in a confusion that which option would I choose , materialized view or Temporary Table. Please list out the advanatages and disadvantages and the situations one option is more preferable than other option.

Thanks in Advance,

(Please take this as urgent)

Sruthi
Re: Materialized view or Temporary Table [message #219106 is a reply to message #219103] Mon, 12 February 2007 23:56 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>(Please take this as urgent)
Why is it urgent for ME to solve this problem for YOU?
Please benchmark BOTH options & select the optimal one and post results back here.
Re: Materialized view or Temporary Table [message #219183 is a reply to message #219103] Tue, 13 February 2007 09:20 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
That's not a question that can be answered without more information. These two things are very very different, and without some idea of what your goal is, we can't advise on which would be best
Re: Materialized view or Temporary Table [message #219435 is a reply to message #219183] Wed, 14 February 2007 06:34 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read this link

A good Introduction for you to the 2 concepts.

Then as JRowbottom says
Quote:
These two things are very very different, and without some idea of what your goal is, we can't advise on which would be best


Good Luck
Previous Topic: duplicate records
Next Topic: dbms_utility.get_parameter_vaue
Goto Forum:
  


Current Time: Fri Dec 02 23:05:08 CST 2016

Total time taken to generate the page: 0.12728 seconds