How to Obtain Index Hints via the Test Profiles Window

Previous Next

See Also

To obtain index hints via the Test Profiles window:

1. In the USoft BenchMark toolbox, double-click Test Profiles in the Test Database list.

The Test Profiles window appears.

2. Perform a query that retrieves the data of the appropriate profile.
3. Click the Index Hints tab page.

The first info box has three fields: Hint No, Table Name, and Available Index.

The Available Index field contains the value 1, 2 etc. if USoft Developer has auto-generated an index on the table's primary, secondary key etc. The field contains a name if an additional index was created manually with the Definer. The field is empty if USoft Developer knows NO index.

4. Scroll through the records, and look for those combinations in which the Available Index field is empty, and the SQL Statements that Generate this Index Hint take up much time.

The Column Name field lists the columns on which you COULD put an index.