No announcements
Found 2932391 threads
-
2 VotesHow understanding the execution plan of a query
Hi, I need to find a detailed documentation (white papers, articles) about how reading/understanding the execution plan ...Answered | 4 Replies | 6789 Views | Created by pscorca - Saturday, June 9, 2012 1:35 PM | Last reply by Soonyu - Sunday, June 10, 2012 4:13 AM
-
0 Votes
understanding execution plan
Sandeep, the following has a pretty good overview of the info provided by an Execution Plan:Answered | 2 Replies | 6370 Views | Created by sandeep437 - Tuesday, January 2, 2007 8:51 PM | Last reply by DannoCoy - Wednesday, January 3, 2007 4:31 AM -
0 Votes
Understanding Estimated Execution Plan
the SELECT list of the query for example. There is a parent topic in the link that I posted that describes how to interpret the ...Answered | 4 Replies | 8384 Views | Created by Amos Soma - Monday, July 24, 2006 5:49 PM | Last reply by Amos Soma - Monday, July 24, 2006 11:40 PM -
0 Votes
Impact of SELECTed colums on the execution plan
FROM tblPerson WHERE id = 993 You can also try execting the query with OPTION (MAXDOP 1) in order to determine if the ...Unanswered | 3 Replies | 6377 Views | Created by Mathieu D - Tuesday, October 17, 2006 1:43 PM | Last reply by Mathieu D - Wednesday, October 18, 2006 12:47 PM -
0 Votes
Query the result of ShowPlan_all Execution Plan
Is there any way I can query the result of execution plan (SET SHOWPLAN_all on) instead of just displaying theAnswered | 4 Replies | 802 Views | Created by SSAS_5000 - Friday, April 10, 2015 6:30 PM | Last reply by Olaf Helper - Tuesday, April 14, 2015 2:24 PM -
0 Votes
View Query Execution Plan
ON'. Then, I use a Resultset submit the query. The query is executed and the execution plan is not ...Unanswered | 2 Replies | 5186 Views | Created by Costa1 - Saturday, September 15, 2007 1:33 PM | Last reply by Costa1 - Tuesday, September 18, 2007 1:23 PM -
0 Votes
Execution plan in query analyzer
This is probably a very stupid question. I have been out of the SQL Server arena for awhile and am now getting re acclimated. It was my understanding thatAnswered | 1 Replies | 4972 Views | Created by tfherrmann - Thursday, January 31, 2008 9:44 PM | Last reply by SQL-PRO - Thursday, January 31, 2008 9:50 PM -
0 Votes
Query Execution plan
Definitely need more info about this. Usually UPDATE STAT should invalidate the execution plan. Can you run your query (assuming it is not a stored ...Unanswered | 4 Replies | 583 Views | Created by kranp - Monday, November 23, 2015 5:23 PM | Last reply by Susantha Bathige - Tuesday, November 24, 2015 3:36 PM -
0 Votes
Query Execution Plan
Have a look here and then work your way through the execution plan for each of the ...Answered | 3 Replies | 5752 Views | Created by Guruprasath B - Friday, March 25, 2011 9:04 AM | Last reply by Abhay_78 - Friday, March 25, 2011 12:28 PM -
0 Votes
Execution Plan query question?
The other parts of the execution plan are fractions of 1% rounded so they display as 0% instead of .05% or .1%. In ...Answered | 4 Replies | 1163 Views | Created by gk1393 - Monday, October 14, 2013 3:47 PM | Last reply by gk1393 - Monday, October 14, 2013 4:14 PM -
0 Votes
Query Execution Plan/cost
Hi Friends, I have situation that I want to capture query cost and execution plan of all query which is executing in sqlserver ...Answered | 6 Replies | 827 Views | Created by malikasad - Wednesday, May 20, 2015 1:51 PM | Last reply by malikasad - Wednesday, May 20, 2015 3:35 PM -
0 Votes
SQL QUERY EXECUTION PLAN
. Please post DDL+DML for the relevant table, and instead of image please post the XML of the ExecutionAnswered | 5 Replies | 534 Views | Created by dbadays - Tuesday, July 19, 2016 7:55 AM | Last reply by pituach - Tuesday, July 19, 2016 5:02 PM -
0 Votes
Error loading Query Execution Plan
Management Studio. I am using the Sql Everywhere CTP on the device, and version 9.00.2047 of the management studio shell. FWIW, when I try ...Answered | 3 Replies | 9530 Views | Created by mrbelk - Thursday, October 26, 2006 9:59 PM | Last reply by Pragya Agarwal [MSFT] - Tuesday, October 31, 2006 5:42 AM -
0 Votes
Query execution plan problem
Hi, I have encountered a problem with a query execution plan on MS SQL Server 2008. It is a simple ...Unanswered | 3 Replies | 5612 Views | Created by Bozena_p - Wednesday, August 25, 2010 4:25 PM | Last reply by Kalman Toth - Friday, September 10, 2010 6:03 PM -
0 Votes
Execution Plan: Query Cost
Scans are never good unless your table/index is very very small. If you see a scan of any type in your execution plan, chances are there is a need to ...Unanswered | 10 Replies | 8074 Views | Created by SQLScript - Saturday, October 4, 2008 3:25 AM | Last reply by paramjit.uppal - Sunday, October 5, 2008 8:58 PM -
0 Votes
Query execution plan in EF
I don't think there is anything built-in that allow you to capture the db-side query execution plan, but there are third-party tools that can do that. One such tool ...Answered | 2 Replies | 5734 Views | Created by coolmanu07 - Wednesday, June 27, 2012 2:19 PM | Last reply by KristoferA - Thursday, June 28, 2012 1:33 AM -
0 Votes
query cost in execution plan
Can this percentage be trusted? I am getting 24% for a small (@ 1000 record) insert into a primary key clustered index, when I know that this is probably about 2% of ...Answered | 2 Replies | 5542 Views | Created by SSAS_5000 - Sunday, April 13, 2008 10:57 PM | Last reply by hoffmanc - Thursday, February 5, 2009 4:02 PM -
0 Votes
SQL Server serial execution plan for a query instead of parallel execution plan
. I 'm reluctant to use any trace hint on production as I understand it seems to be a bug in query optimizer. Because in ...Discussion | 6 Replies | 1568 Views | Created by Niting123 - Thursday, February 5, 2015 11:11 AM | Last reply by Niting123 - Friday, February 6, 2015 2:40 PM -
0 Votes
estimated execution plan vs actual execution plan
acctual execution plan Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readersAnswered | 1 Replies | 1165 Views | Created by Sakura Data - Wednesday, March 5, 2014 9:51 PM | Last reply by Shanky_621 - Wednesday, March 5, 2014 10:01 PM -
0 Votes
Change of Execution plan
degarded. The execution plan has changed. Now, this looks like there's lot of work if we have to tune each query w.r.t the new execution ...Unanswered | 2 Replies | 6438 Views | Created by Ritesh305 - Tuesday, September 5, 2006 1:25 PM | Last reply by Ritesh305 - Friday, September 8, 2006 4:29 AM - Items 1 to 20 of 2932391 Next ›
No announcements
