What kind of SQL workload should I capture 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.