15.10 - Preferences - Teradata Index Wizard

Teradata Index Wizard User Guide

prodname
Teradata Index Wizard
vrm_release
15.10
category
User Guide
featnum
B035-2506-035K

The Preferences window allows you to set the connectivity type, default directory for saved files, and several other options. They include the QCD Access option, Execute SQL option, and the Data Demographics capture option.

For more information on connecting using ODBC or CLIv2 see the following:

  • “Connecting Through ODBC” on page 36
  • “Connecting Through CLIv2” on page 37
  • 1 Click Tools > Options> Preferences.

    The Preferences dialog box opens.

    2 Use the tabs to select the setting you want.

    The following table explains each tab in the dialog box.

    3 Click OK.

     

    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.