SQL Access advisor rejects my SQL
I'm running a test with SQL access advisor and I select a tuning set with a couple of SQLs. From the initial options I selectVerify use of access structures ...... Then I select the tuning set and submit the job. When I see the results I get the message:
There are no SQL statements to process for task SQLACCESS1631154
Then I check further and I see:
Filter Summary: Invalid table reference: Statements discarded: 2
Why is that? The statements are correct since I selected them from TOP Activity. I run as SYS.
There are no SQL statements to process for task SQLACCESS1631154
Then I check further and I see:
Filter Summary: Invalid table reference: Statements discarded: 2
Why is that? The statements are correct since I selected them from TOP Activity. I run as SYS.
0