Retrieve Index Recommendations and Data Collection Information

Use the ttIndexAdviceCaptureInfoGet and ttIndexAdviceCaptureOutput built-in procedures to retrieve the data collection overview and Index Advisor recommendations. Run either or both for the data you want.

1. Call the ttIndexAdviceCaptureInfoGet built-in procedure to retrieve data collection overview information for the Index Advisor. See Retrieve Data Collection Information with ttIndexAdviceCaptureInfoGet.

2. Call the ttIndexAdviceCaptureOutput built-in procedure to retrieve the recommended indexes. See Retrieve Index Recommendations with ttIndexAdviceCaptureOutput.

3. After a DBA has evaluated the recommended index creation statements, apply the desired index creation recommendations.