Timeline for Trying to speed up a report that takes freaking forever
Current License: CC BY-SA 2.5
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 18, 2011 at 21:00 | comment | added | AnonJr | "Clustered Index Scan Testing_TestLogs" seems to cost 92%; Seems to be related to the sub-query. | |
| Mar 17, 2011 at 9:29 | comment | added | Mongus Pong | In Management Studio select Query -> Include Actual Execution Plan. Then run your query. You will get an Execution Plan tab next to your results. This will be massive, but well worth going over. It shows all the operations that SQL Server had to do together with the Cost. Find the items with the highest cost. | |
| Mar 16, 2011 at 18:36 | comment | added | AnonJr | It is massive, and there are indexes on the ID columns. I've tried to get some execution plans, but I'm not sure I'm running them right... my SQL Server knowledge comes more "trial by fire" than "excellence in education" | |
| Mar 16, 2011 at 13:09 | history | answered | Mongus Pong | CC BY-SA 2.5 |