반응형
/**********************************************************************************************
-- Title : [2k5] 향상된 DBCC SHOH_STATISTICS
-- Reference : mcpworld.com
-- Key word : dbcc show_statistics density_vector histogram stat_header
**********************************************************************************************/
use adventureworks;
go
dbcc show_statistics ('person.address',ix_address_postalcode);
go
dbcc show_statistics ('person.address',ix_address_postalcode)
with stat_header;
--with density_vector;
--with histogram;
go
반응형