Searching for table index
Use this procedure to search for table indexes of M3 Business Engine (BE) system and version.
- On the Search tab, click Search By System Configuration.
- In the Keywords field, specify a keyword to search.
- Select an MDP BE System to use.
- Select an entity: Table Index.
-
Click the link to More Options for
additional search filter.
- Select a Component.
- Set the Search Limit. The default value is 500.
-
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.
-
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.
-
- To view index relations, click View Index Keys.