sys.query_store_plan

Description

2016 (13.x) and later versions SQL database in Microsoft Fabric Contains information about each execution plan associated with a query.

Syntax

<major>.<minor>.<build>.<revision>

Examples

Example 1

sp_query_store_reset_exec_stats

Example 2

SELECT txt.query_text_id,
txt.query_sql_text,
pl.plan_id,
qry.*
FROM sys.query_store_plan
AS pl
INNER
JOIN sys.query_store_query
AS qry
ON pl.query_id = qry.query_id
INNER
JOIN sys.query_store_query_text
AS txt
ON qry.query_text_id = txt.query_text_id;
EXECUTE sp_query_store_reset_exec_stats 3;