I have a SQLServer 2005 database withseveral tables, each containing between 10 and 40 million records. Eachtable has a clustered index (which clusters data into blocks of about100,000 records or so based on customer), as well as 2 or 3non-clustered indexes (primary key, order codes). I have a maintenanceplan that runs nightly for each table: DBCC DBREINDEX ('Table') WITH NO_INFOMSGS; These plans run with no errors, and if I check at night, the indexes all seem to have .01% fragmentation, or something similar. Yet, by 8am the next morning, all of the non-clustered indexes are 97to 99.999% fragmented. The odd thing is, no users have been on thesystem. No data has been added/deleted/modified. Has anyone else experienced such behavior? If so, were there any solutions? Thanks!