Displaying keys and indexes of database tables - 6.3

Talend MDM Platform Studio User Guide

EnrichVersion
6.3
EnrichProdName
Talend MDM Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

After analyzing the content of a database as outlined in Creating a database content analysis, you can display the details of the key and user-defined index of a given table. This information could be very interesting for the database administrator.

Prerequisite(s): At least one database content analysis has been created and executed in the studio. For further information, see Creating a database content analysis.

To display the details of the key and user-defined index of a given table in the analyzed database, do the following:

  1. In the Analysis Results view of the analysis editor, click a catalog or a schema under Statistical Information.

    All the tables included in the selected catalog or schema are listed along with a summary of their content: number of rows, keys and user-defined indexes.

  2. In the table list, right-click the table and select View keys.

    You can not display the key details of tables in a Hive connection.

    The Database Structure and the Database Detail views display the structure of the analyzed database and information about the primary key of the selected table.

    If one or both views do not show, select Window > Show View > Database Structure or Window > Show View > Database Detail.

  3. In the table list, right-click the table and select View indexes.

    You can not display the index details of tables in a Hive connection.

    The Database Structure and the Database Detail views display the structure of the analyzed database and information about the user-defined index of the selected table.

  4. If required, click any of the tabs in the Database Detail view to display the relevant metadata about the selected table.