>You're right, I see that this is a table hint
>http://msdn.microsoft.com/en-us/library/ms181714.aspx
>
>Did you read the blog I sent you earlier in this thread (about possibility to experiment with LOOP JOIN)?
>
>If you post your query and how many records each table has (and which indexes), it will be easier to discuss the problem.

I will have to take a look at that later on. But, I cannot right now as this situation is from the List class and this is based on property constructions only. And, to be able to support such an approach would require several weeks of adjustment in the architecture of that class. So, we are trying various alternatives. Hopefully, we will have one acceptable soon.