重建索引-DOL表

检查表是否为 datarows sp help ETS FLEX VALUE SET go Name Owner Object type Object status Create date ETS FLEX VALUE SET dbo user table none Aug 26 2011 6 55PM 1 row affected Column name Type Length Prec Scale Nulls Default name Rule name Access Rule name Computed Column object Identity CODE varchar 20 NULL NULL 0 NULL NULL NULL NULL 0 NAME varchar 255 NULL NULL 0 NULL NULL NULL NULL 0 DESCRIPTION varchar 255 NULL NULL 1 NULL NULL NULL NULL 0 IS INNER char 25 NULL NULL 1 NULL NULL NULL NULL 0 MAINTAIN FLAG char 25 NULL NULL 1 NULL NULL NULL NULL 0 CREATION DATE varchar 25 NULL NULL 1 NULL NULL NULL NULL 0 CREATED BY int 4 NULL NULL 1 NULL NULL NULL NULL 0 LAST UPDATE DATE varchar 25 NULL NULL 1 NULL NULL NULL NULL 0 LAST UPDATE BY int 4 NULL NULL 1 NULL NULL NULL NULL 0 ENABLED char 1 NULL NULL 1 NULL NULL NULL NULL 0 FLEX VALUE SET ID varchar 32 NULL NULL 0 NULL NULL NULL NULL 0 Object has the following indexes index name index keys index description index max rows per page index fillfactor index reservepagegap index created index local ETS FLEX VALUE SET I1 CODE FLEX VALUE SET ID nonclustered 0 0 0 Oct 28 2011 1 08PM Global Index ETS FLEX VALUE SET PK FLEX VALUE SET ID clustered unique 0 0 0 Oct 28 2011 1 08PM Global Index 2 rows affected index ptn name index ptn seg ETS FLEX VALUE SET I1 2002103142 default ETS FLEX VALUE SET PK 2002103142 default 2 rows affected No defined keys for this object name type partition type partitions partition keys ETS FLEX VALUE SET base table roundrobin 1 NULL 1 row affected partition name partition id pages row count segment create date ETS FLEX VALUE SET 2002103142 2002103142 1 49 default Oct 28 2011 1 08PM Partition Conditions NULL Avg pages Max pages Min pages Ratio Max Avg Ratio Min Avg 1 1 1 1 000000 此为 datarows 1 000000 Lock scheme Datarows The ascinserts attribute is not applicable to tables with datarow or datapage lock schemes exp row size reservepagegap fillfactor max rows per page identity gap ascinserts 0 0 0 0 0 0 1 row affected concurrency opt threshold optimistic index lock dealloc first t