Displays information about how long it took to insert or delete rows from an index.
0 – 3
0
Can be set for an individual connection or the PUBLIC group. Takes effect immediately
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” in the Sybase IQ System Administration Guide.
