Home » SQL & PL/SQL » SQL & PL/SQL » Materialized views (10g,11g)
Materialized views [message #569472] Fri, 26 October 2012 17:51 Go to next message
ramana290
Messages: 3
Registered: October 2012
Location: chennai
Junior Member
Hi,

I have created materialized view which hold few million records.Should i have to analyse the view and compute the statistics after i create the materialized view?

Also,just in case i need further indexing,should i have to take the statistics for the table again??
Any response will be highly appreciated.

Thanks in Advance,
Venkata Ramana M
Re: Materialized views [message #569473 is a reply to message #569472] Fri, 26 October 2012 18:54 Go to previous messageGo to next message
BlackSwan
Messages: 22515
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Materialized views [message #569478 is a reply to message #569472] Sat, 27 October 2012 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, yes, it is better.

Regards
Michel
Re: Materialized views [message #569480 is a reply to message #569478] Sat, 27 October 2012 01:47 Go to previous messageGo to next message
ramana290
Messages: 3
Registered: October 2012
Location: chennai
Junior Member
Am i doing something wrong here? Is the question not clear?
Re: Materialized views [message #569484 is a reply to message #569480] Sat, 27 October 2012 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Didn't I answer the questions?

Regards
Michel
Re: Materialized views [message #569496 is a reply to message #569472] Sat, 27 October 2012 13:58 Go to previous message
ramana290
Messages: 3
Registered: October 2012
Location: chennai
Junior Member
Ya..Got it..Thanks a lot Smile
Previous Topic: opposite of listagg
Next Topic: basic DBA project
Goto Forum:
  


Current Time: Mon Jul 28 17:42:31 CDT 2014

Total time taken to generate the page: 0.14617 seconds