sys.fn_validate_plan_guide

date-time
#date-time#function

Description

Verifies the validity of the specified plan guide. The returns the first error message that is encountered when the plan guide is applied to its query. An empty rowset is returned when the plan guide is valid. Plan guides can become invalid after changes are made to the physical design of the database.

Syntax

sys.fn_validate_plan_guide