You should capture the most representative SQL workload that created performance problem in your system. For example, if there was a performance problem at 11:00 AM yesterday, you should extract this SQL workload from AWR for index recommendation.
You should capture the most representative SQL workload that created performance problem in your system. For example, if there was a performance problem at 11:00 AM yesterday, you should extract this SQL workload from AWR for index recommendation.