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...

Thanks, Provides a good (and brief) overview of resource locking and lock investigation as well.