Table 2-4: Changed commands
Command
|
Change
|
|---|
alter table
|
Syntax added to support computed and
materialized or non-materialized columns. Adds support for paritions.
|
create index
|
Enhanced to allow computed columns to
be used as index keys, in the same way as regular columns, and to
create function-based indexes. Adds support for paritions.
|
create table
|
Syntax added to support computed and
materialized or non-materialized columns. Adds support for paritions.
|
dbcc
|
Adds support for partitions.
|
declare cursor
|
Syntax added for scrollable cursors.
|
delete statistics
|
Adds support for partitions.
|
disk init
|
The size parameter
can be specified in terabytes.
Adds the directio parameter, which allows
you to configure Adaptive Server to transfer data directly to disk,
bypassing the operating system buffer cache
|
disk reinit
|
Adds the directio parameter,
which allows you to configure Adaptive Server to transfer data directly
to disk, bypassing the operating system buffer cache
|
declare cursor
|
Syntax added to support semi_sensitive, insensitive,
and scrollable cursors.
|
fetch
|
fetch_orientation options added
to support scrollable cursors: next, prior, first, last, absolute,
and relative.
|
reorg
|
Adds support for partitions.
|
select
|
for xml clauses added
to support XML services. Adds support for partitions.
|
truncate table
|
Adds support for partitions.
|
update all statistics
|
Adds support for partitions.
|
update statistics
|
Adds support for partitions.
|
update partition statistics
|
Obsoleted
|
