onedbguru@yahoo.com wrote in news:1164392562.354785.112340
@f16g2000cwb.googlegroups.com:

> because you do not have an index on AdminID, SaveDate and SentDate.
>
> create index ue_idx on `UserEmails` (`AdminID`, `SaveDate`,
> `SentDate`).....


That doesn't help at all, and I can't see why it would considering that the
table causing problems isn't UserEmails but ProjFiles.... the ProjFiles
table is the one being scanned.