Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
v_s
Starting Member
2 Posts |
 Posted - 2008-04-08 : 12:36:41
|
| I am running a SELECT on a table. This READ operation ends up going through Clustered Index Scan. I want to know whether Clustered Index Scan , blocks other concurrent transactions trying to INSERT into this table? Does Clustered Index Scan locks the entire clustered index? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-08 : 12:49:41
|
| the scan reads keys page by page. locking depends on the transaction isolation level._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
v_s
Starting Member
2 Posts |
Posted - 2008-04-08 : 14:26:01
|
| It is Read Committed. If so what kind of Lock SQL Server 2000 takes when it does clustered index scan? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-08 : 23:50:08
|
| Page lock by default unless you use lock hint in the query. |
|
|
|
|
|
|
Clustered Index Scan