What to do about this super slow query
I have a query on a relatively small database that could not return the results after 12 hours of processing! I've tried different types of indexing with only minor results (when I reduce the results time period (where) to a year from fifteen years) Is it a large number of joins causing this? Any help/suggestions greatly appreciated!
Query attached
Do you have the estimated execution plan?
You say small, what is small? What are the record counts in each of the databases?
