| _覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
|
FrontPage › DBCCShowContig伎
|
|
|
[edit]
1 DBCC ShowContig 覓碁 #覓碁 れ螻 螳朱, 誤 襷 谿瑚. 螳讌 旧 る 蟆 螻, 襷 谿場覲企伎 襷蟆 覃 .
DBCC SHOWCONTIG
[ ( { table_name | table_id | view_name | view_id }
[ , index_name | index_id ]
)
]
[ WITH { ALL_INDEXES
| FAST [ , ALL_INDEXES ]
| TABLERESULTS [ , { ALL_INDEXES } ]
[ , { FAST | ALL_LEVELS } ]
}
]
[edit]
2 #DBCC SHOWCONTIG 企螻 碁煙れ 譟郁 襯 覲 覈轟企. 2005危 覯 蟯襴 觀(sys.dm_db_index_physical_stats)襯 伎. れ 蠏 る企.
DBCC ShowContig('test_table')
DBCC SHOWCONTIG(螳) ' test_table ' 企 れ 譴...
企: 'test_table' (677577452); 碁煙 ID: 1, 一危磯伎 ID: 5
TABLE 譴 れ 給.
- れ 伎................................: 100
- れ 旧ろ..............................: 17
- 旧ろ..............................: 16
- 旧ろ 蠏 伎 ........................: 5.9
- れ 覦[豕:れ].......: 76.47% [13:17]
- 朱Μ れ 譟郁 ..................: 0.00%
- 旧ろ れ 譟郁 ...................: 82.35%
- 伎 螳ロ 蠏 覦危 .....................: 138.6
- 蠏 伎 覦(豌).....................: 98.29%
DBCC ろ 襭給. DBCC る 覃讌襯 豢ロ覃 ろ 蟯襴蟆 覓語.
[edit]
3 蟆郁骸 伎 #
鏤
|
覈 蟆 蟆 瑚 蟆伎 (启) |