Package element: NotableQueryPlan
Properties
| Name | Value |
| CreationName | |
| DataType | String |
| Description | |
| EvaluateAsExpression | True |
| Expression | "SELECT [sql_handle],{LF} [plan_handle],{LF} [statement_start_offset],{LF} [statement_end_offset],{LF} [creation_time]{LF}FROM [snapshots].[fn_get_notable_query_plans](" + (DT_WSTR, 10) @[User::SourceId] + ")" |
| IncludeInDebugDump | False |
| Name | NotableQueryPlan |
| Namespace | User |
| QualifiedName | User::NotableQueryPlan |
| RaiseChangedEvent | False |
| ReadOnly | False |
| SystemVariable | False |
| Value | SELECT [sql_handle],{LF} [plan_handle],{LF} [statement_start_offset],{LF} [statement_end_offset],{LF} [creation_time]{LF}FROM [snapshots].[fn_get_notable_query_plans](1) |
| VariablePath | \Package\SEQ - Capture and analyze query statistics and query plan and text\DFT - Create Interesting Queries Upload Batch.Variables[User::NotableQueryPlan] |
See also