Doubt on the Index Validation part of the Index Wizard!!
I worked on the Index wizard available in the Demo package and I would like to know how we use the validate index option in real time.
It was stated that since we often use the index wizard in the Test environment (with a TSET, for performance reason) we might not have actual data in the test system and Validate option is used to test the cost savings on the recommended indexes with statistics. It was said that it basically tests the impact of statistics.
I would like to know if validate index option is always used to test the recommended indexes in a Production environment or if it can be used in some other ways too.