It is Materialized view which may make application faster (performance may improve , but not necessariy)
Views when refrenced, Run in real time and execute the queries against the original table, so the performance may be same as original query Materialized view , when runs for the first time, Executes the query against the original tables, gets the result set and stores it into a table, For futher references of the table it will get fetch results from the stored table (and does not need to go to the original tables) Materialized View will have the static data though, any changes in original tables will not be reflected unless refreshed again. Thanks, Avinash On Sat, Jul 18, 2009 at 2:45 AM, Rob Wolfe <wolfe....@gmail.com> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
