The Before and After graphs were generated by perfmon from real production data on the same weekday in 2 different weeks. The client (Travidia) supplied the graphs showing the performance improvement. Improved indexing reduces CPU utilization by reducing the amount of data scanned in tables stored in RAM, reducing hash joins and reducing the need for sorting. The trick is to identify which new indexes will provide the most bang for the buck. The tuneSQLServer.com methodology identifies high cost queries and priortizes improvements so that you get important performance improvements fast. You get improvements which benefit your daily operations after the first day of having us on the job. These improvements boost the capabilities of your system and reduce stress on your employees, managers and customers.