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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy