Enabling Indexed Views/Summary Tables

Access the Change Properties page (PeopleTools, and then Utilities, and then Administration, and then Materialized Views, and then Enable Materialized Views).

The page includes a list of the views delivered from applications. You can select specific views to enable or disable indexed views/summary tables feature.

This example illustrates the Change Properties page for Microsoft SQL Server database, followed by descriptions of the columns on the page.

Change Properties page for materialized views in Microsoft SQL Server database

Field or Control	Description
Enable?	Select to convert the view as an indexed view or summary table.
Disable?	Select to convert the indexed view or summary table to a normal SQL view.
Indexed View/Summary Table Name	Enter the name of the indexed view or summary table. You can use the prompt for selecting the name.
Status	Displays Enabled or Disabled depending on the current status of the view.

Save the page after you select the views to enable or disable indexed views/summary tables. Open the ENABLEMV project in the Application Designer and build the project to render the selected views as indexed views/summary tables. Similarly, open the DISABLEMV project in the Application Designer and build it to convert the indexed views/summary tables to normal SQL views.