This content has been marked as final.
Show 1 reply
-
1. Re: NOLOCK equivalent hint in Teiid
shawkins Feb 2, 2017 1:12 PM (in response to sanjay_chaturvedi)1 of 1 people found this helpfulAs long as you are not doing any updates on the source table, you could change it's name in source property to "name WITH (NOLOCK)" rather than just "name". Otherwise an enhancement would be required to look for an analogous source hint (Federated Optimizations · Teiid Documentation ) and place it in the source query in the correct location.