HiRDB SQL Tuning Advisor is a product designed to help you locate and resolve SQL performance bottlenecks. It analyzes execution records output by HiRDB servers and clients, and displays the results together with advice in an easy-to-understand format.

HiRDB SQL Tuning Advisor provides the following features:

• Efficiently locates SQL code that might cause performance problems.
• Efficiently tunes SQL code that might cause performance problems.

HiRDB SQL Tuning Advisor provides the following two main facilities:

• SQL trace analysis facility
  The SQL trace analysis facility analyzes SQL trace information generated by the HiRDB client, and displays on screen the aggregate time in the units occupied by the UAP or SQL code. This enables you to locate SQL code bottlenecks by summing the SQL processing time and extracting SQL code that is taking a long time to execute.
  
• Access path analysis facility
  The access path analysis facility analyzes and displays on screen access path information generated by the HiRDB client. It can also graphically display the join relationships between tables. It can locate areas that might cause performance problems with respect to the methods used to join the tables (table scan, cross-join, and so on) and display warning advice.
  

In order to use HiRDB SQL Tuning Advisor on a HiRDB client, you must have either HiRDB/Developer's Kit or HiRDB/Run Time. For details about the prerequisite products, see the HiRDB SQL Tuning Advisor's Release Notes.