>>Why this was not optimized? Do you have indexes on NoMember2 and Numero ?
>
>Yes, all the indexes are there but SQL Server cannot go optimized on that one. Or, maybe it is but 0.001 vs 0.3 is a big difference to me.
Can you post both query execution plans? I'm curious now.
If it's not broken, fix it until it is.
My Blog 
