During normal database usage, inserts, updates and deletes will put your indexes out of order, slowing down performance. When this happens, you need to defrag your indexes.
SQL Defrag Studio 2009 is the perfect solution to this problem. SQL Defrag Studio makes fragmentation easy to understand with a simple interface and easy-to-follow recommendations for which indexes are in a bad state.
Simply run SQL Defrag Studio to identify which indexes are fragmented and then defrag only where it's needed. Once SQL Defrag Studio has put your indexes back in order, your queries will run quickly again.
Includes scheduler, color-coded graphical display, index usage statistics, unused indexes and support for XML, Full Text and Filtered indexes, and indexes on geospatial and geometery columns.