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.
  4. Select an entity: Table Index.
  5. Click the link to More Options for additional search filter.
    • Select a Component.
    • Set the Search Limit. The default value is 500.
  6. Click Search.

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

    Index Name
    The 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
    The parent table of the index.
    Parent Table Description
    The description of the parent table.
    Component
    The component of the index.
    Key Info
    The option to view the keys of an index.
    Condition Info
    The condition information of an index.
    Join Table
    The join table of an index.
    Join Condition
    The join condition 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 specify a dynamic free text filter for each column.

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