Question: what is the difference between index and statistics?
Answer: One major difference between indexes and column statistics is that indexes are permanent objects that are updated when changes to the underlying table occur. Column statistics are not updated. ... Another difference is the effect that the existence of new indexes or column statistics has on the optimizer.