Adaptive Server® Enterprise (ASE) is a highly scalable, mission critical database server that provides a portable, multi-platform system for high performance data management.The new features of ASE 15.0 deliver an operational advantage with lower cost and risk, and they achieve higher performance on mixed workload systems. Testing with ASE 15.0 has shown an advantage in overall performance for transaction processing over MySQL 5.0, and many complex queries show significant improvements.

The new query optimizer and execution engine greatly enhance the performance of complex queries. ASE 15.0 features patented query-processing technology that increases query performance and, when coupled with features such as Computed Columns and Function Indexes, significantly reduces reporting time on mission critical reports. Sybase ASE 15.0 provides new features and functionality that can handle severe user demands for performance and economy.This paper will discuss how ASE 15.0 delivers advanced DSS performance on data sets of all sizes—from small to the VERY large—while controlling your costs. Some of the features that improve query performance are hash- based algorithms, merge joins, and N-ary joins.

Download