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.