Perhaps I’m missing something here, and couldn’t find another case of this in the forum.
I initially populated the SQL Workload area from the SGA, and it identified 4000+ queries. It took nearly a day to validate all that SQL, and then when I ran the index tuning, it hung at 11% when preparing index data.
I assumed my workload was too big - so I then marked all 4000+ queries as “ignored by user”, and then selected the top 20 queries from an aggregate elapsed time perspective. I kicked off the index search process again, and it seems to be going through all 4000+ queries to validate them. I would have expected this to be limited to just those 20 I had selected for “in use”.
Is this expected behavior? I can’t delete any of the queries in the collection, can only mark as in use or ignored …