Views are best used when you need to restrict different users/groups for multiple numbers of limited view of the entire table. E.g. From the Employee table, you want to allow all employees to view details about all others employees' Names and Department, but want to allow only the Senior Managers to view the entire detail of the employees including wages, address, band etc. So you will allow the employee group with SELECT access on view V_EMP_Contact and will grant SELECT access to group created for the managers on view V_EMP_DETAILs which has got the entire details for all employees ( from the EMPLOYEE table). There are many other uses of Views as well like your table contains too many fields, whereas almost all the user queries are interested only in a subset of the same.
For Materialized query tables, as you correctly mentioned, they are created for performance primarily and are physical copies in the form of a table of the query output that is embedded in the definition of the MQT. There are lot many white papers and redbooks available on MQTs in the net.
Last edited by JAYANTA_DATTA; 08-01-11 at 13:48.
DB2 UDB DBA
IBM India, Global Delivery