????????????????????????????????????????????????л???????????????????У?????????????????????????

????????????????????????????????????????????ж?λ???????β??????????????

???????????￡???в??????????????????????????????????????????????????????????????????????????????????????????

??????????????????????????????????????????м????

??????????????????綽????????????????????Helen Meyer???????????綽????????????????????? “Fernandez?? Zelda”?? “Olsen?? Karl”?????????????5??431.????????431???????????????Kumar?? Kevin”??“Nara?? Alison”?????????????5??2006??????????5??2006??????????????????

???????????

???????????????????????????????е?????SQL Server????????????SQL Server????????????????????м????????????????????????????????????????????????10???е????????????????????????5???????1???????????????????3??IO??

??????????????????????????????????????????????С??????????AdventureWorks?????????У??????????????????3?????????????????????????????????????и???????

????sys.dm_db_index_physical_stats?????????????????????????????С???????????????????????????????????????SalesOrderDetai???????????????

 

SELECT  OBJECT_NAME(P.OBJECT_ID) AS 'Table' ??
        I.name AS 'Index' ??
        P.index_id AS 'IndexID' ??
        P.index_type_desc ??
        P.index_depth ??
        P.page_count
FROM    sys.dm_db_index_physical_stats(DB_ID()??
                                       OBJECT_ID('Sales.SalesOrderDetail')??
                                       NULL?? NULL?? NULL) P         JOIN
sys.indexes I ON I.OBJECT_ID = P.OBJECT_ID
                              AND I.index_id = P.index_id ;

??????????????2?????

?2.???sys.dm_db_index_physical_stats???????????

??????′????????????????????????

 

SELECT  OBJECT_NAME(P.OBJECT_ID) AS 'Table' ??
        I.name AS 'Index' ??
        P.index_id AS 'IndexID' ??
        P.index_type_desc ??
        P.index_level ??
        P.page_count
FROM    sys.dm_db_index_physical_stats(DB_ID()??
                                       OBJECT_ID('Sales.SalesOrderDetail')?? 2??
                                       NULL?? 'DETAILED') P         JOIN
sys.indexes I ON I.OBJECT_ID = P.OBJECT_ID
                              AND I.index_id = P.index_id ;