Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 41)

Displaying Materialized View Indexes and Their Properties

To display the materialized view index information:

1. Start the HP Database Manager and log on using any user ID.

2. Click the Database area.

3. Select a system in My Active Systems in the navigation tree.

4. Select a Schema in the navigation tree.

5. Open the Materialized Views folder, select and open a Materialized View.

6. Open the Indexes folder and select a materialized view index in the tree.

In the right pane, these tabs appear:

• Columns tab (user only)

• Attributes tab

• DDL tab

• Partitions tab

Columns Tab

To display the materialized view index columns:

1. Select a Schema in the navigation tree.

2. Open the Materialized Views folder, select and open a materialized view.

3. Open the Indexes folder and select a materialized view index in the tree.

4. Click on the Columns tab in the right pane.

In the right pane these attributes are displayed:

• Column Name: Name of the column (string).

• Sort Order: Specifies the order as “Ascending” or “Descending.”

• Added By: Indicates if column was added by the “System” or “User.”

Displaying Materialized View Indexes and Their Properties 41

1 2 ... 36 37 38 39 40 41 42 43 44 45 46 ... 69 70

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 41