New Features in Adaptive Server 15.0.2

Adaptive Server 15.0.2 introduces many new features and enhancements. They include enhancements to security, encrypted columns, and performance. New features include archive database access, deferred compilation, eager and lazy aggregate processing, and user-defined SQL functions.

• Encrypted Columns
  Adaptive Server Enterprise 15.0.2 provides enhancements to encrypted columns
• Archive Database Access
  Validate or selectively recover data from a database dump (an “archive”) by making the dump appear as if it is a traditional, read-only database (an "archive database")
• Finding Slow-Running Queries
  Adaptive Server 15.0.2 introduces new set commands that collect information about slow-running queries.
• Deferred Compilation
  Adaptive Server 15.0.2 introduces deferred compiling. Using deferred compilation, the optimizer can compile stored procedural statments that reference real runtime values.
• Case-Insensitive Sort Orders for Chinese and Japanese Character Sets
  This section describes case-insensitive sort orders for these Chinese and Japanese character sets:
• Statistical Aggregate Functions
  Adaptive Server 15.0.2 introduces statistical aggregate functions to compute variance and standard deviation
• Eager and Lazy Aggregation
  Aggregate processing summarizes large amounts of data with an aggregated value.
• Improved Performance for Data Insertion
  Adaptive Server 15.0.2 optimizes performance of data insertion
• Changes to the Query Processor
  These modifications to the query processor describe behavior changes that can affect query plan selection.
• Viewing Current Optimizer Settings
  A new fake table sysoptions and a new stored procedure sp_options let you view optimizer settings.
• New Security Features
  New security features in Adaptive Server 15.0.2
• Installing and Editing Monitoring Tables
  Adaptive Server version 15.0.2 includes new installation and editing features for monitoring tables.
• Monitoring Tables for the Statement Cache
  Two new monitoring tables let you analyze the contents of the statement cache.
• Row-Level Locking for System Tables
  Adaptive Server version 15.0.2 uses row-level locking on system tables to enhance performance.
• The xmltable() Function
  xmltable() creates a SQL table from elements in an XML table.
• Relocated Joins
  Relocation joins permits joins between local and remote tables to locate to remote server.
• User-Defined SQL Functions
  Adaptive Server 15.0.2 introduces user-defined SQL functions.
• instead of Triggers
  Use instead of triggers to override default triggering actions.