Preferences - Teradata Index Wizard

Options

Description

Connectivity tab

ODBC

Select this option to create a connection using ODBC. For more information, see “Connecting Through ODBC” on page 36.

CLI

Select this option to create a connection using CLIv2. For more information, see “Connecting Through CLIv2” on page 37.

Path tab

Default Directory

Enter the directory where you want files stored when saved. Use the Browse (...) button to browse.

General tab

Use X views (DBC and QCD)

Check this box to set Index Wizard to use information of Data Dictionary and QCD captured by the logged on user only.

If a message appears to create restricted views, click Yes to create the missing views, or click No to continue without X views.

Note: For additional information on X views, see “Creating Restricted DBC Views” on page 141.

Use X views (QCD only)

Check this box to set Index Wizard to use QCD information captured by the logged on user only.

Note: For additional information on X views, see “Creating Restricted DBC Views” on page 141.

Use SQL Assistant instead of Execute SQL Query window

Check this box to have Teradata SQL Assistant execute SQL statements (default).

Capture demographics to objects referred in workload

Check this box to have Index Wizard capture additional information for Data Demographics. This option is used when a workload is created by using statement text or by using the DBQL.

Select sample size for statistics collection

Select the sample size (percentage) to be used for statistics collection during query capture when defining a workload from DBQL statements or using SQL statement text. The default is 100.

Default perm space for QCD creation (MB)

Enter the default space in megabytes that you want to use for a QCD when creating a workload.