However, I want to see your execution plan

Try to execute it and show result XML, please

It seems that index on Mid is missed or not used

SELECT a.Mid, a.Ph, a.msg, a.dd,...

CrazyMan (5/28/2008)

---

Thanks Mwolf

I am taking off all the records on a temp table, so i...

No, no

🙂

I mean duration of SELECT execution.

I guess that your trouble is very slow INNER JOIN. So I try to found another way to delete data

Something like this:

DELETE a ...

ok

Let try from another side.

How much time is this query being...

May you show us Actual Execution Plan of DELETE statement?

And table definitions of OQa with all its indexes too