Good Man wrote:

> 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.
>
>

sorry, overlooked that in your description...

What in your query makes some rows in ProjFiles more selectable? Since you did
not exclude or include any ProjFiles values in your where clause, of course it
needs to scan the whole table.


--
Michael Austin.
Database Consultant