I did eventually get this to work, though it makes little sense. It turns out that dropping all the indexes on the table was the answer. With indexes the query...

I thought those things as well.

I have completely re-built the table and rebuilt the indexes, still have the performance issue.

I have also made sure that code was the only...

While I can give the DDL for this, I don't think that this is a normal issue. I am good myself at performance tuning. It seems to be something unusual....

I have not been able to get an execution plan out of the query now that it is slow, 11+ hour run time is making it difficult to say the...