we have a client who used the maintenace plan like this link: http://www.mssqltips.com/tip.asp?tip=1013 They have "reorganize data and index pages" checked. Second radiobutton under it checked with value of 10. Also , "remove unused space" checked. I checked one of the main tables with dbcc showcontig and dentsity was 71%. Some other tables had density of 75% or less. They run this once a week. They also update statistics. Database is4 GB. If that maintenace plan reindexes, howcome density is still at 71%? Also, do they need recompile stored procs after they reindex?