TT SQL TRACE Flags
Show the full text of a query with an ID number
In the Option Dialog dialog box, select . On the BDB/SQL Tracing tab, select , or, from the command line, run TT_SQL_TRACE=040.
Show how long a query has been running
In the Option Dialog dialog box, select . On the BDB/SQL Tracing tab, select , or, from the command line, run TT_SQL_TRACE=0200.
Show main SQL functions such as SQLExec, SQLParse, SQLFetch, and SQLBind
In the Option Dialog dialog box, select . On the BDB/SQL Tracing tab, select , or, from the command line, run TT_SQL_TRACE=02000.
Show the best possible design for indexing, joins, and so on
In the Option Dialog dialog box, select . On the BDB/SQL Tracing tab, select , or, from the command line, run TT_SQL_TRACE=04000.
Show all full table scans
In the Option Dialog dialog box, select . On the BDB/SQL Tracing tab, select , or, from the command line, run TT_SQL_TRACE=020000.
Show low-level communication between client and driver
In the Option Dialog dialog box, select . On the BDB/SQL Tracing tab, select , or, from the command line, run TT_SQL_TRACE=040000.
Show current time to level of milliseconds: YYYYMMDDhhmmss.mmm
In the Option Dialog dialog box, select . On the BDB/SQL Tracing tab, select , or, from the command line, run TT_SQL_TRACE=0400000.
TT_SQL_TRACE value
Shows the current setting that can be used in a –set TT_SQL_TRACE=<value> from the command line.