Hi Guys,
I've been playing with the DTA (Database Tuning Advisor) and if I tried to optimize a query it then suggests some recommendations to create indexes and statistics. My question is what are the purpose of the statistics? Will they occupy huge disk space? Are they going to affect the speed on retrieving, updating and inserting data?
Thanks in advance....
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.