truncate precomputed result set

Truncates the data in a precomputed result set.

Syntax

truncate {precomputed result set | materialized view}
	[owner_name.]prs_name

Parameters

precomputed result set | materialized view – specifies whether to truncate the data in a materialized view or precomputed result set.
prs_name – name of the precomputed result set. A fully qualified prs_name cannot include the server or database name.

Examples

Example 1 – Truncates the authors_prs precomputed result set:
```
truncate precomputed result set authors_prs
```

Usage

truncate precomputed result set automatically alters the precomputed result set to disable. To reenable the precomputed result set, issue refresh precomputed result set.

Permissions

You must be the precomputed result set owner to run truncate precomputed result set.