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.