set

The set command enables the ins_by_bulk parameter for the session, which improves performance by directly inserting data rows into newly allocated data pages for tables. The syntax is:

set ins_by_bulk {on | off}

The join_bloom_filter parameter enables or disables the use of bloom filters for query plan optimization. The syntax is:

set join_bloom_filter {on | off}

The parallel_plan_detail_html parameter generates a graphical query plan in HTML format containing information about details per thread and plan fragments for query plans that are executed in parallel using several worked threads. Use this option to diagnose the behavior of specific threads and plan fragments in comparison with the global execution of the query. The syntax is:

set statistics parallel_ plan_detail_html {on | off}

The plan_detail_html parameter generates a graphical query plan in HTML format containing information details of plan operators, such as the name, different timestamps captured during the execution, number of rows affected, number of estimated rows, elapsed time, and so on. The syntax is:

set statistics plan_detail_html {on | off}

The plan_directory_html parameter specifies the directory path name into which to write the HTML query plans. The file name is identified by a combination of user name, spid, and timestamp. The syntax is:

set statistics plan_directory_html {dirName | on | off}

The plan_html parameter generates a graphical query plan in HTML format containing information about the number of rows and number of threads per operator. The syntax is:

set statistics plan_html {on | off}

The timing_html parameter generates a graphical query plan in HTML format containing execution statistics related to the timing spent in each operator per execution phase. CPU usage and Wait distribution is generated for queries executed in parallel. The syntax is:

set statistics timing_html {on | off}