Teradata

Teradata Visual Explain visually displays the query execution plan generated by the Teradata Optimizer so that query planners and DBAs can immediately see where improvements can be made and can rewrite certain query sections for analysis. It allows you to visually compare two execution plans to determine if a proposed change will have the desired effect. In addition, it can help application developers and DBAs fine-tune the SQL statements to ensure the Teradata Database accesses data efficiently.

Teradata Index Wizard automates the process of picking secondary indexes for a given database and workload — a natural grouping of queries — to maximize system performance. Index Wizard evaluates secondary index selection candidates and recommends the optimal indexes. It also analyzes use of current secondary indexes to identify whether they are being used effectively. Index recommendations can be analyzed on a test system and validated on the production system to reduce implementation costs.

Teradata Statistics Wizard collects usage and performance statistics so that other Teradata performance analysis tools can analyze them. It analyzes specified workloads or databases and creates a recommended list of statistics collection operations. This list is then presented to you for review so you can check or uncheck items in the list and schedule the collection job.

Teradata System Emulation Tool allows you to quickly project a production environment by emulating a larger production system in a smaller test or development environment, reducing the cost of query plan analysis and overall development efforts. It also allows you to model the impact of schema changes by analyzing graphical comparisons of query plan reports showing information such as DDL, statistics, indices and random AMP samples.