Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT qsq.query_id,
- qsq.object_id,
- qsqt.query_sql_text,
- Cast(qsp.query_plan AS XML) AS QueryPlan
- FROM sys.query_store_query AS qsq
- JOIN sys.query_store_query_text AS qsqt
- ON qsq.query_text_id = qsqt.query_text_id
- JOIN sys.query_store_plan AS qsp
- ON qsp.query_id = qsq.query_id
- WHERE qsq.object_id = Object_id('dbo.ProductTransactionHistoryByReference')
Add Comment
Please, Sign In to add comment