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://qa.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://qa.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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply