thanks for the replies.
These are consolidated sql servers on QA and prod with more than 80 databases on them.  one sql server on each server.
That's probably why QA...

Thanks.
Removing cross join does remove the index spool eager spool.  it runs in about 16 min now in prod.
Not sure if this is what the results should be as...