reorgchk
本帖最后由 doushi 于 2010-08-20 09:40 编辑SCHEMA.NAME CARD OV NP FP ACTBLK TSIZEF1F2F3 REORG
----------------------------------------------------------------------------------------
表: Table
- - - - - - - - - ---
----------------------------------------------------------------------------------------
SCHEMA.NAME INDCARDLEAF ELEAF LVLSNDEL KEYS LEAF_RECSIZE NLEAF_RECSIZE LEAF_PAGE_OVERHEAD NLEAF_PAGE_OVERHEADPCT_PAGES_SAVEDF4F5F6F7F8 REORG
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
表: Table
索引: I_Table01
- - - - - - - - - - - - - - - - -----
索引: P_Table
- - - - - - - - - - - - - - - - -----
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
如上图所示reorgchk之后统计信息怎么都是空呢? 把你所做的哪些过程(执行哪些命令)发来看看 空的是好消息吧,如果到处都是*就有问题了。
页:
[1]