May 11, 2010 at 12:49 am
Hi.. I have more than 2000 line query.In that query is fully written by derived tables.. if i excute this query.. hardly it will take 10 to 15 minutes.. Could you pls help me.. to reduce the execution time..
May 11, 2010 at 1:11 am
You have also posted in the 2000 forums , please confirm which version you are using.
Also please read this http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2010 at 1:16 am
I'm using sql 2005
May 11, 2010 at 1:36 am
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 11, 2010 at 6:56 am
Without the things that Gail asked for the only suggestion I can make is, reduce the size of the query. Any query 2000 lines long is probably going about stuff the wrong way.
"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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply