>>Yes.
>>I don't understand why would EXISTS cannot utilise a compound index.
>
>But, EXISTS cannot benefit of a compound index from the master table but only on its related child table into where it would search.
Probably I don't understand the type of query you are doing. If you have all the values hardcoded then go with that.