New Features in Adaptive Server 15.0

Adaptive Server 15.0 introduces support for data partitions, row-locked system catalogs, an enhanced query processor, large identifiers, computed columns scollable cursors, new datatype support, XML enhancements, support for interactive SQL, enhancements to SySAM and the Adaptive Server Plug-in, user-defined Web service support, and security enhancements.

• Partition Support
  Partitioning is useful in managing large tables and indexes by dividing them into smaller, more manageable pieces. Partitions, like a large-scale index, provide faster and easier access to data.
• Row-Locked System Catalogs
  Many system catalogs can now use a datarows locking scheme.
• Query Processor
  Adaptive Server 15.0 provides an enhanced query processor
• Large Identifiers
  Adaptive Server 15.0 introduces expanded limits for delimited identifiers
• Computed Columns
  Computed columns and function-based indexes provide easier data manipulation and faster data access.
• Scrollable Cursors
  Adaptive Server Enterprise 15.0 supports both scrollable and nonscrollable cursors.
• unitext Datatype Support
  Adaptive Server 15.0 supports the vaiable-length unitext datatype.
• big int Datatype Support
  Adaptive Server version 15.0 supports the exact numeric datatype bigint.
• Unsigned Integer Datatype Support
  Adaptive Server 15.0 supports unsigned integer datatypes.
• Integer Identity
  Adaptive Server 15.0 allows you to use certain datatypes as identity values.
• Enhancements to XML Services
  XML enhancements in 15.0 include XML schema support, for xml clause enhancements, and Unicode (I18N) support.
• Adaptive Server Plug-in Enhancements
  Adaptive Server 15.0 includes enhancements to the Adaptive Server Plug-in.
• Interactive SQL
  Interactive SQL allows you to execute SQL statements, build scripts, and display database data to the server.
• User-Defined Web Services
  Web Services lets you create Web services and execute SQL in Adaptive Server.
• Very Large Storage Support
  Adaptive Server 15.0 extends the allowable number of disk devices and the allowable number of 2K blocks for each device.
• Automatic Running of update statistics
  Run the update statistics command automatically at times that suit your site.
• SySAM License Management
  The Sybase Software Asset Management (SySAM) implementation has changed.
• Query Processing Metrics (qp Metrics)
  Query processing (QP) metrics identify and compare empirical metric values in query execution. When a query is executed, it is associated with a set of defined metrics that are the basis for comparison in QP metrics.
• Updates to Abstract Plans
  Adaptive Server 15.0 supports enhancements to the query processor.
• showplan Changes
  The Adaptive Server 15.0 version of showplan better represents the steps performed by the query processor.
• Secure Socket Layer Uses FIPS 140-2
  In Adaptive Server 15.0, the SSL uses cryptographic modules validated for FIPS 140-2, level 1.