Home » SQL & PL/SQL » SQL & PL/SQL » materialized view and summary table
materialized view and summary table [message #430657] Wed, 11 November 2009 09:13 Go to next message
ukaraogul
Messages: 5
Registered: October 2009
Location: turkey
Junior Member
Hi All
I have a question.
what is difference Materialized View from summary table management?
or
why I should use materialized view or summary table management?

Thanks in advance!

Re: materialized view and summary table [message #430658 is a reply to message #430657] Wed, 11 November 2009 09:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is "summary table management"?

Regards
Michel
Re: materialized view and summary table [message #430660 is a reply to message #430657] Wed, 11 November 2009 09:23 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
In Oracle, what I understand is mataterialized view = summary table

To know more about Materialize view(MV) search in www.tahiti.orcle.com


MV is a view that can be used to summarize, precompute, replicate, and distribute data.



[Updated on: Wed, 11 November 2009 09:26]

Report message to a moderator

Re: materialized view and summary table [message #430662 is a reply to message #430660] Wed, 11 November 2009 09:45 Go to previous messageGo to next message
ukaraogul
Messages: 5
Registered: October 2009
Location: turkey
Junior Member
Its_me_ved wrote on Wed, 11 November 2009 17:23
In Oracle, what I understand is mataterialized view = summary table

To know more about Materialize view(MV) search in www.tahiti.orcle.com


MV is a view that can be used to summarize, precompute, replicate, and distribute data.





ok thanks i will look oracle documentation.
Is summary management and summary table not same?
Re: materialized view and summary table [message #430666 is a reply to message #430662] Wed, 11 November 2009 10:05 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
We don't know what you mean by 'Summary Management' and 'Summary Table'

Those are not terms with a special meaning in the context of Oracle.
Previous Topic: CLOB - Appending CLOB in for loop.
Next Topic: Encountered the symbol "end-of-file" when expecting one of the following
Goto Forum:
  


Current Time: Fri Dec 02 18:21:24 CST 2016

Total time taken to generate the page: 0.07081 seconds