Truncates the data in a precomputed result set.
truncate {precomputed result set | materialized view}
[owner_name.]prs_name
specifies whether to truncate the data in a materialized view or precomputed result set.
name of the precomputed result set. A fully qualified prs_name cannot include the server or database name.
Truncates the authors_prs precomputed result set:
truncate precomputed result set authors_prs
truncate precomputed result set automatically alters the precomputed result set to disable. To reenable the precomputed result set, issue refresh precomputed result set.
You must be the precomputed result set owner to run truncate precomputed result set.
