Index Locks

Is it true that index locks would occur when the index's on a table are being reorganized ? Would this also exclusively lock the table ?
How serious are these Locks in performance ? Will these lead to [upd-stat] locks ?
Am encountering a lot of index locks in my db on the temp tables, Could using fillfactor on create index statement would lessen these locks ?
IDX: 2:544547798:1412364626 [[INDEX_ID]]
IDX: 2:1610018179:0 [[INDEX_ID]]
Thanks a lot.Yes, if you are rebuilding a clustered index, your table will be locked.
Greg Jackson
PDX, Oregon|||Will the Sqlserver automatically rebuid the index on Temp tables whenever there are lot of updates/inserts ? If it does that , and these updates/inserts are in a transaction could it eventually lead up to contention ?
Thanks!!
"Jaxon" wrote:
> Yes, if you are rebuilding a clustered index, your table will be locked.
>
> Greg Jackson
> PDX, Oregon
>
>|||sql will update statistics. It will not rebuild the Index
Further, you can turn auto update statistics off if you really want to.
(Directions in Books On Line)
GAJ