Home » SQL & PL/SQL » SQL & PL/SQL » Difference between Table and Materialized View
Difference between Table and Materialized View [message #212057] Wed, 03 January 2007 11:57 Go to next message
mrpranab
Messages: 32
Registered: March 2005
Member
Hi,

Wish a very Happy New Year to all of you...

Can you tell me what's the difference between table and materialized view as both are storing data in the database. When should we use materialized view and when not...

Thanks in advance...

Pranab...
Re: Difference between Table and Materialized View [message #212061 is a reply to message #212057] Wed, 03 January 2007 12:09 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Basic Materialized Views for the information on the subject.
Previous Topic: insufficient privileges For EXECUTE IMMEDIATEEXPLAIN PLAN...,
Next Topic: Extract Year
Goto Forum:
  


Current Time: Thu Dec 08 04:25:10 CST 2016

Total time taken to generate the page: 0.08868 seconds