Displays information about how long it took to insert or delete rows from an index.
0 to 3
Can be set for an individual connection or the PUBLIC group. Takes effect immediately
0
DDL_OPTIONS2 displays messages telling how long it took to insert or delete rows in each index. The following settings are allowed:
0 — Suppress messages
1 — Show messages on insert operations, such as LOAD TABLE
2 — Show messages on delete operations
3 — Show messages on insert and delete operations
For example, the following command displays messages that show how long it took to insert rows in each index:
SET TEMPORARY OPTION DDL_OPTIONS2 = 1
2004-04-06 09:24:10 0000000002 [20902]: Insert completed. Index 'yahoo.DBA.ASIQ_IDX_T200_C10_FP', in 0 seconds.
“Interpreting notification messages” in Chapter 7, “Moving Data In and Out of Databases”of the Sybase IQ System Administration Guide
