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.