DBCC SHOWCONTIG

Vilasgite080
Posted by Vilasgite080 under Sql Server category on | Points: 40 | Views : 3177
DBCC SHOWCONTIG : SQL SERVER2005
At the time of table or table index fragmented heavily that time we will scan and find out status of table or table index by
DBCC SHOWCONTIG command. Table fragmentation (Fragmentation means joining together) occurs when a large number of
insert and update operations are performed on table.
Syntax:  
DBCC SHOWCONTIG
[
(table_name[,index_name])
]

For Example :

DBCC SHOWCONTIG (STUD,STUD_INDEX)

Here, STUD is table and STUD_INDEX is index on table...

Comments or Responses

Login to post response