View Full SQL

This page is accessed via Configuration and Administration > Technical Support > Diagnostics and Tools > Database > SQL Performance. Choose Actions > View Full SQL.

This displays a window showing the full SQL string, formatted so it is easier to read. Use this window to examine the SQL query in detail and help troubleshoot query performance.

For any fields where you can manually enter SQL, you can have the database plan your SQL by clicking the Explain Plan button and analyze your explain plan or SQL with AI by clicking the OTM Assistant button.