|
Your SQL Server indexes help the query engine find data as fast as possible for the best query performance every time.
The Query Optimizer uses indexes to quickly find data so it doesn't need to do a full table scan which is often inefficient.
During normal database usage, inserts, updates and deletes will put your indexes out of order, slowing down query performance.
When this happens, you need to defrag your indexes.
Visual Defrag 2007 is the perfect solution to this problem. Visual Defrag makes fragmentation easy for you to understand with a
simple interface and easy-to-follow recommendations for which indexes are in a bad state.
Simply run Visual Defrag to identify which indexes are fragmented and then defrag only where it's needed. Once Visual Defrag
has put your indexes back in order, your queries will run quickly again. Visual Defrag makes SQL Server faster.
Don't just defrag it, Visual Defrag it! |