Hi, Nadya.
>I meant for the single operation, not for SCAN/ENDSCAN. E.g. if you look into _ri_handler by Steve Saywer/Doug Henning, they use Select-SQL in order to check, if the key exists. I changed it to indexseek. With scan/endscan + indexseek vs. Select-SQL, I would prefer Select-SQL.
It would be interestig to see the case. I'm not sure if this is something generic or maybe an isolated problem. Could you post the code or sample to discuss it?
Thanks,