SQL Guide : Diagnostics and troubleshooting for SQL
Diagnostics and troubleshooting for SQL
solidDB® provides the following diagnostic tools for troubleshooting SQL:
▪SQL info facility and the EXPLAIN PLAN FOR statement used to tune your application and identify inefficient SQL statements in your application
▪Tracing facilities for stored procedures and triggers
You can use these facilities to observe performance, troubleshoot problems, and produce high quality problem reports. These reports let you pinpoint the source of your problems by isolating them under product categories (such as solidDB® ODBC API, solidDB® ODBC Driver, or solidDB® JDBC Driver).