Hi Guys,

Thanks for all of your insights so far. As a side note, the query in both environments returns zero records. The way I know is that if I force...

Hi Grant,

Thanks for your suggestions.

Making clustered indexes is not an option right now. There are no indexes on WC_EPCR_GA_OWNERSHIP_H, which is why you see the full scan. There are less...

Hi Folks,

Thanks so much!

I've attached the requested information.

CAVEAT: I can't get actual execution plan from PROD because the query never completes (i've let it run close to 8 hours), so...