This BRCONNECT command option controls the information written to the detail log.

Input syntax: -o|-output [detail|process|summary][,time]

Default value: process

·        detail: Writes detailed processing information to the log file. The log file is then comprehensive, which can be helpful to investigate problems.

·        process: Writes detailed information to the log file, including the analysis methods and sample sizes for updating the index statistics while statistics are being checked. These are used to determine whether tables need new statistics.

·        summary: Writes only summary information and total counts to the log file. This can be useful for creating initial statistics to avoid a large log file.

·        time: Generates additional time stamps that enable you to determine the time required for the individual operations.