25000 inner loops is the issue.
I could easily force it to use hash and make it perform better.
Have you tested that and seen that forcing a hash join improves performance in all cases?
I think the order in which the joins are done is bad. I am looking for some assistance in changing the order.
Order of joins won't affect the type of join chosen, unless you go forcing join types that is. Are your stats correct and your row estimates accuate?
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass