Hi,


To be able to evaluate the folowing

> OR
> (Exists ( select 1
> from discussion DS
> where DS.Deal_ID=D.ID
> AND DS.CreateDate >= '3/1/2008' ))
> OR
> (Exists ( Select 1
> from Attachment A
> where A.Deal_ID=D.ID
> AND A.CreateDate >= '3/1/2008' ))
>

the engine must visit all records from "D", so, there's no way to use the
index you wish, I *think*


Regards,
Anderson Farias