After the Index Suggestion Engine (ISE) creates an index for a slow query, you can
test the index to see if it improves the query time.
This test is a quick assessment of the index and is not
part of the 14-day index evaluation
process.
If
you are evaluating an index suggestion on a non-production instance, you can run this
test after creating the index to get immediate results on index performance.Note: Index
test results from your non-production instance may not necessarily predict similar
performance results on your production instance.
-
Open the Index Suggestion record for the index
to
be tested:
-
Navigate to .
-
In the Index Suggestions table, click the
Table
name for the index
to
be tested.
-
In the Index Suggestion record, click Test Performance
to start the performance test.
-
When the Test Index Suggestion progress indicator shows that testing is
complete, click Go to Result.
-
In the Query Performance Test Results form, compare the Average with
index and Average without index fields to
see if the index improved the query time.
In the following example, the index improved the query time. The
Forced check box is unchecked, indicating that the
database is using the index. If the check box is checked, the database was
forced to use the index during the test but is not using the index outside of
the test.
-
Click the back arrow to navigate back to the Index Suggestion record for the
table. The result of this index performance test does not change the index state
recorded in the Index Suggestion record.
