I met a strange problem when defragmenting indexes by re-creating indexes. If I re-create indexes in SQL Server Enterprise Manager and then check fragmentation with DBCC SHOWCONTIG, value of SCAN DENSITY will be increased ,which means fragmentation situation has been improved. But if I try to defragment by running statement DROP INDEX followed by CREATE INDEX in SQL Query Analyzer, value of SCAN DENSITY of DBCC SOWCONG has no change. It seems defragmentation doesn't benefit from DROP/CREATE INDEX. DBCC DBREINDEX and DBCC INDEXDEFRG don't work too. Have you ever met such problems? Any suggestion? Thanks.