Component running slow
Attached query is running slow , approx 3.5 hours on one of our reporting server running:
SQL server 2005, with 10 GB of RAM, on win 32 bit 2003 with AWE enabled.
This would be the enterprise edition.
Database in question where query is being run is 180 GB data +150 GB indexes.
Therefore i am trying to figure indexes sitting out there if that worthy of that size, are they good enough to be so, as still the query runs very slow.
Please help for any suggestion on how should i go ahead with tuning this.