Drop Data Collected for the Index Advisor and Finalize Results

After you have applied the CREATE statements for the new indexes that have been approved by the DBA, you can drop the captured data collected for the Index Advisor. The ttIndexAdviceCaptureDrop built-in procedure drops the existing data collected for the specified captureLevel, which can either be a connection or database-level capture.

Call ttIndexAdviceCaptureDrop(0);

You must call this built-in procedure twice to drop both a connection-level and database-level capture. You may not invoke this built-in procedure while a capture at the same level is in progress.

Note:

See ttIndexAdviceCaptureDrop in the Oracle TimesTen In-Memory Database Reference.

You can repeat the steps in Prepare for Running the Index Advisor and Retrieve Index Recommendations and Data Collection Information until a SQL workload runs with no more index recommendations. You can keep updating the statistics for the tables on which the new indexes were applied and re-run the Index Advisor to see if any new indexes are now recommended.