February 4, 2013 at 2:02 pm
I am trying to observe the graphic execution plan, but my query is big. Is there any way that I can turn off the top part of the execution plan window - the Query and missing index session? Because every time I move my mouse, it's like trying to load that big query. Thanks.
February 4, 2013 at 2:23 pm
You can load the plan into SQL Sentry Plan explorer. It is a lot more user friendly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2013 at 3:55 am
You can't turn that part off.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 5, 2013 at 8:04 am
Thank you.
February 6, 2013 at 6:32 am
I agree with SQLRNNR - SQL Sentry Plan Explorer is a good product. There's a free version and a paid version, which is pretty cheap. It gives you the "Oracle Explain Plan"-style view in a grid in addition to an improved graphical view.
February 13, 2013 at 6:07 am
shanghaigirl-1125377 (2/4/2013)
I am trying to observe the graphic execution plan, but my query is big. Is there any way that I can turn off the top part of the execution plan window - the Query and missing index session? Because every time I move my mouse, it's like trying to load that big query. Thanks.
Just avoid that section with your mouse
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply