solidDB Help : Programming : Diagnostics and troubleshooting SQL
  
Diagnostics and troubleshooting 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).
See
Observing performance
Tracing facilities for stored procedures and triggers
Measuring and improving performance of START AFTER COMMIT statements