On Jul 18, 2:11 am, weird0 <amiredi...@gmail.com> wrote: > I would like to know what is the difference between a View and > Materialized View? > > As far as my knowledge goes, view holds the result of select query > from tables. It makes the application faster because the result-set is > not calculated at run-time. > > Mview is set to be refreshed on some basis i.e. daily, weekly and > monthly. as opposed to view. > > Please confirm. > > Regards, > Software Engineer
As far as my knowledge goes, you have almost a completely incorrect understanding of a view. A view does not, in my experience, speed anything up. I might be incorrect in certain cases but I do not think that it is much more than a way to look at a possibly complex join in a way that is easier for mere mortals. Certainly I have never seen a lot of evidence that this is the case. Rob --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
