Dynamic histograms allow you to specify columns for which a new range cell is dynamically maintained at the end of an existing histogram.
For DML operations on this column, the new range cell includes the maximum value and dynamically maintains a row count.
The boundaries of the original cells of the histogram remain unchanged, but the weights of the original cells are proportionally decreased as the weight of the new cell is increased.
update statistics( , ...) ... [using dynamic_histogram [ on | off ] ...
mount and unmount encrypted databases the same as mounting unencrypted databases
The master key and database encryption keys stored in the master database must be the same.
SAP ASE allows you to use the select into command against permanent and temporary tables in multistatement transactions
Use the create database ... index_compression parameter to create databases that include compressed indexes.
Use the alter database ... set index_compression to enable or disable index compression on existing databases.
sp_help terse – allows you to determine the amount, and the content, of information displayed by sp_help.
sp_helpartition terse – allows you to determine the amount, and the content, of information displayed by sp_helpartition.
sp_helpindex terse – allows you to determine the amount, and the content, of information displayed by sp_helpindex.