Searching for table index

Use this procedure to search for table indexes of M3 Business Engine (BE) system and version.

  1. On the Search tab, click Search By System Configuration.
  2. In the Keywords field, specify a keyword to search.
  3. Select an MDP BE System to use.

    See System configuration fields.

  4. Select an entity: Table Index.

    See M3 BE entities.

  5. Click the link to More Options for additional search filter.
    1. Select a component.
    2. Set the search limit. The default value is 500.

    See System configuration advanced search.

  6. Click Search.

    On the Search Results tab, the Entity: Total match, and a data list with this information is displayed:

    Column heading Description
    Index Name Name of the index
    Unique "Yes" indicates that the index is unique and there can only be one unique key for every table.
    Parent table Parent table of the index.
    Component Component of the index.
    Key info Option to view the keys of an index.
  7. Use these options to sort and filter your results:

    • To sort the results alphabetically or numerically, click the Sort icon located in one or more column headings.

    • To filter the results, click the Filter icon in the last column and type a dynamic free text filter for each column.

  8. To view index relations, click View Index Keys.

    See Viewing index keys.