>Can you post an image of the execution plan and the query?
>
>Nested loops can happen (in some instances) when an equal sign is used with a subquery instead of an IN/EXISTS . Not sure that's what's going on here, but if you can post the details, we can look at it.
I have attached a view of the region of the execution plan.
I also added next to it the yellow rectangle related to it.
I have basically almost two identical queries. One is ok. The other one is showing this red x. The main difference seems to be related to a WHERE clause which uses a different index. I have one index created to satisfy the minimum needs. I created another one like the first one but with about 10 additional fields in the index list because users can search in various fields. The one which has the red x is the one having a lot of fields in the index list.