refresh precomputed result set

Syntax

refresh precomputed result set prs_name 

Parameters

• prs_name – name of the precomputed result set. A fully qualified prs_name cannot include the server or database name.

Examples

• Example 1 – Refreshes the au_prs precomputed result set:

  refresh precomputed result set au_prs

Usage

refresh precomputed result set permission defaults to the precomputed result set owner and can be transferred to other users.

Standards

The refresh precomputed result set command is a Transact-SQL extension and is not covered by the SQL standard.

Permissions

You must have create table privilege to refresh precomputed result sets.

Auditing

Refreshing precomputed result sets is not audited.