Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mitche027
Starting Member
3 Posts |
 Posted - 2014-03-24 : 11:11:47
|
Good day I’ve been trying to optimize this query for a time now.. Originally all the joins are together so what I did was utilize temporary tables and divided the joins into two part… I lessened the query’s execution time a bit but it still takes some time for the query to execute especially it has to return about 20,000 data.. may you kindly help me further execute my query.. QUERT TOO LONG... KINDLY DELETE THIS POST. executionplan: http://www.sendspace.com/file/r44q87 quote:
|
|
|
ScottPletcher
Aged Yak Warrior
550 Posts |
Posted - 2014-03-24 : 14:08:33
|
| I was going to look at the execution plan, but the download site is just too polluted. |
 |
|
|
|
|
|
How do I Optimize this Query