Igor Micev (4/27/2015)
Ok,If you create an index on Lotno,Kapan and Position it should improve the selection in the where condition.
where Lotno=@Lotno
and Kapan=@Kapan
and Position='CURRENT'
Ensure Lotno is the first key column in the index:
create non-clustered index IX_Entry_Jangad_Lot_index1 on Entry_Jangad_Lot(Lotno,Kapan,Position)
No improvements after this also.