A. A single SQL statement provided by a user
B. An existing SQL Tuning Set(STS)
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources
答案:(A, C, D)
解析:
《2 Day DBA》 10.3.2
可以对下面的输入使用SQL Tuning Advisor:
1. Top Activity
2. Historical SQL
3. SQL Tuning Set