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