Generating Materialized View Index DDL Commands

Display the data description language SQL code for adding an index to a materialized view. The SQL code can be a useful reference and training tool.

Prerequisites
Database Version Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4

None.
SAP Sybase IQ 16.0

None.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects > Views, and then select Materialized Views.
  3. Select a materialized view from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
    The Materialized View Properties view appears.
  4. In the left pane, select Indexes.
  5. Select one or more indexes from the right pane and click Generate DDL.
    Note: Use Shift-click or Control-click to select multiple indexes.
  6. Click Generate DDL.
    The DDL window shows the SQL code used to add the selected index to the table or materialized view.
Parent topic: Materialized View Indexes