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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
