Truncate and refresh the materialized view to increase performance.
Truncation cleans up stale materialized view data without deleting the view definition, and
without removing any rows from the underlying table.
Prerequisites
| Database Version |
Materialized View Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
You must have one of:- DBA authority
- You own the materialized view
|
| SAP Sybase IQ
16.0 |
You must have one of:- TRUNCATE ANY TABLE system privilege
- ALTER ANY TABLE system privilege
- ALTER
ANY OBJECT system privilege
- TRUNCATE permission on the materialized view
- You own the materialized view
|
Task
Materialized view data is read-only. Materialized views are only supported for system
store (IQ catalog store) tables.
- In the Perspective Resources view, select the resource, and
select .
- In the left pane, expand , and then select Materialized Views.
- Select one or more materialized views from the right pane and either:
- Click the arrow to the right of the name and select Truncate
Data, or
- From the Administration Console menu bar, select .
Note: If the Truncate Data option is unavailable, refresh the
data first.
Tip: Use Shift-click or
Control-click to select multiple materialized views.
- Click Yes to confirm truncation.