You can create an index associated with the columns of a query table, which is a special type of view available in Oracle and DB2. These indexes are called view indexes. Query table indexes behave like indexes defined on tables, they are data structures that improve database performance and access speed. You normally create indexes for columns that you access regularly, and where response time is important.
For more information about query tables, see Creating a query table.