• Without an index, the database will have to perform a table scan meaning it will check each row in the table so it will place a lock on each of the rows to ensure none of them change while it does the processing.

    william (7/8/2009)


    When there is no index, why database engine need to place RID lock on both row 1 & 2?