To troubleshoot a SQL statement that is causing the majority of I/O on your system, you can use the SQL Tuning Advisor and the SQL Access Advisor.
Option A) SQL Tuning Advisor - This advisor is responsible for analyzing the SQL statement's execution plan and providing recommendations to improve its performance. It suggests potential changes to the SQL statement, such as creating or modifying indexes, restructuring the SQL statement, or gathering statistics. This advisor can help optimize the execution plan and reduce the I/O impact caused by the SQL statement.
Option B) SQL Access Advisor - This advisor focuses on recommending changes to the physical schema to optimize the performance of SQL statements. It suggests creating or modifying indexes, partitioning tables, or using materialized views to improve query performance. By optimizing the access paths and data retrieval methods, the SQL Access Advisor can help reduce the I/O impact caused by the SQL statement.
Option C) Both A and B - This option is correct because both the SQL Tuning Advisor and the SQL Access Advisor are suitable for troubleshooting the SQL statement causing I/O issues. By using both advisors, you can get comprehensive recommendations to improve the performance of the SQL statement and minimize its I/O impact on the system.
Option D) Neither A nor B - This option is incorrect because both the SQL Tuning Advisor and the SQL Access Advisor are relevant in this scenario. They provide valuable insights and recommendations to troubleshoot and optimize the SQL statement causing I/O issues.
Therefore, the correct answer is option C) Both A and B.