Setting the TLE - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2506
Product Category
Teradata Tools and Utilities

TLE is a feature that enables you to emulate a production environment on a completely different and foreign environment.

When TLE options are imported and enabled, the Optimizer generates plans relative to the emulated production environment rather than the local environment. This enables you to confidently perform and test administrative and performance enhancing modifications, such as indexing, without the risk of saturating or altering the production environment.

1 From the Import File dialog box, click Set TLE.

The Set Target Level Emulation dialog box opens with the Set RAS tab active. The following figure shows the Set Cost Profile tab active.

2 Fill in the dialog box.

The following table describes the options in this dialog box.

 

Option

Description

Set RAS tab

Select Table Names

Shows the workload tables selected.

Session and System

Selects the RAS level you want. This option allows the user to analyze the imported workload in the same session.

Select All

Selects workload tables in the Select Table Name grid.

Set Costs tab

Select Cost Tag window

Shows the cost tags. This option allows the user to analyze the imported workload in the same session.

Session, IFP, System

Selects the cost level you want for the workload.

Set Cost Profile tab

Select Cost Profile Tag window

Shows the cost profile tags. This option allows the user to analyze the imported workload in the same session.

Session, IFP, System

Selects the cost profile level you want for the workload.

3 Click Apply.

4 Click OK to return to the Import File dialog box.