Post reply

locking queries

  • August 11, 2013 at 9:06 am

    #296905

    what type of locking will be happens when user executed

    select * from table.

    what type of locking will be happens when user executed

    update table set col1=23 where col2=100

    when we have index in col2 what type of lock will be called.

    when we don't have index in col2 what type of lock will be called.

  • August 11, 2013 at 10:56 am

    #1640414

    The select will take a shared lock, probably at the table level. The update will take an exclusive lock, can't tell what granularity without knowing more about indexes and data distribution, could be row, page or table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply