Commands

Adaptive Server 15.7 SP100 contains changed commands.

Changed commands
Command	Description
alter database	Adds the off parameter, which specifies the device names from which you are releasing space.
create index	The online parameter lets you create indexes without blocking access to the data you are indexing. You may execute parallel create index for a clustered index on a data-only-locked table using the sorted_data parameter. Use the with statistics hash-based option and additional hash option clauses to gather index statistics on tables.
create materialized view	You cannot include a like clause with create materialized view that includes an immediate refresh parameter.
create precomputed result sets	You cannot include a like clause with create precomputed result set that includes an immediate refresh parameter.
dbcc	For every data partition undergoing incremental reorganization, a row is stored in `sysattributes`. Use the new dbcc parameter zapdefraginfo to delete this information in `sysattributes` before performing a downgrade.
dump database	A new cumulative allows you to specify a backup as a cumulative incremental dump.
load database	A new cumulative type allows you to load a backup created with the dump database cumulative keyword.
reorg	The defrag parameter lets you to schedule and resume reorganization while also allowing concurrent reads or writes on the data being reorganized.
select	The ins_by_bulk parameter improves performance by directly inserting data rows into newly allocated data pages by bulk for tables. Set the parameter at the query level using the abstract plan for a specific insert statement.
set ins_by_bulk	The set command enables the new ins_by_bulk parameter for the session, which improves performance by directly inserting data rows into newly allocated data pages for tables.
set join_bloom_filter	Enable or disable the use of bloom filters for query plan optimization.
set statistics plan_detail_html parallel_ plan_detail_html plan_directory_html	Generate a graphical query plan in HTML format Generate a graphical query plan in HTML format containing execution statistics related to the timing spent in each operator per execution phase Generate 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 Generate a graphical query plan in HTML format containing information details per thread and plan fragments for query plans that are executed in parallel using several worked threads. Specify the directory path name into which to write the HTML query plans.
update statistics	update statistics acquires memory from the default data cache instead of `tempdb` buffer cache if the session is using a `tempdb` bound to an inmemory device.