|
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. |
|
