• I think I have a pretty good understanding about building and tuning queries, and the use and creating of indexes.  What I am not sure about is statistics.  In working on slow performance of our PeopleSoft Finance system after upgrading to SQL Server 2005, I ran an hour long trace and used that with DTA.  It recommended we build 35 indexes and a lot more multi-column statistics.  We have implemented those recommendations and have seen a significant improvement in performance.  I can understand how the indexes help, but how do the statistics?  If you are doing this manually, how do you decide if a statistic is more appropriate than index?  Without going into a 3 to 30 page explaination, how are statistics used to improve query performance?

    Or should I invest in the book I mentioned earlier by Karen Delaney?

    Also, I work for a school district, training funds are very sparse.