Index Wizard (IW) and its Features

• GUI tool that provides Automated Process for IMPROVING PERFORMANCE through use of INDEXES on a PARTICULAR WORKLOAD.
• Gives step by step process by Analyzing a DB’s workload and Gives Suggestions for IMPROVING QUERY PERFORMANCE.
• Support PPI, can recommend to use it in WORKLOAD if it can Increase Performance.
• Gives SI recommends in Workload as well.
• It can be started from TD Visual Explain, TD SET, TD Statistics Wizard, TD Manager & vice-versa except TD-Manager cannot be started from Index Wizard (IW)

• Index Wizard (IW)  Allows:    
• To validate Index Recommendations.
• To perform “What-if” analysis on workload.
• To schedule Index Creation.

• Index Wizard (IW)  needs Demographics Information to perform Index Analysis and to make Recommendations.
• We can collect following types of Data Demographics using SQL.
• Query Demographics:
•  Use the INSERT EXPLAIN statement with the WITH STATISTICS and DEMOGRAPHICS clauses to collect table cardinality and column statistics.
• Table Demographics:
•  Use the COLLECT Demographics statement to collect the row count and the average row size in each of sub-tables in each AMP on the system.