Re: cursor stability isolation mode

abhishek wrote: > Hi, > > In order to get a shared lock (using cursor stability in a transaction) > on a particular row is it necessary to use "select * from tab_name > where..."? Or at least "SELECT some_column_in_tab_name FROM tab_name WHERE ...;"{ > I tried with "select 1 from tab_name where..." and the only lock I am > getting is IS lock on the entire table instead of S lock on the fetched > row. That's because IDS is too smart for it's own good. The optimizer realized that you only wanted back a set of '1's so it only has to get a count of matching rows, which it can do purely from the indexes without fetching and locking ANY data, then it just returns the constant buffer containing '1' that many times. Art S. Kagel > Regards, > Abhishek >