Sybase IQ is a high-performance decision-support server designed specifically for data warehouses and data marts. This cross-platform product runs on Linux, Windows, Solaris, HP-UX, and AIX operating systems. Sybase IQ 15.x is the latest release of the Sybase Inc. flagship analytic server, delivering high performance in loading large volumes of data and processing very complex queries.
Sybase IQ 15.x offers various new features, such as enhanced support for parallelizing queries, improved subquery performance, support for 3-byte FP index, enhanced use of HG indexes for improving the performance of order-by queries, reduced temporary space usage for queries, and improved load performance.
This paper highlights the query and load performance improvements of Sybase IQ 15.x in comparison to the Sybase IQ previous release, Sybase IQ 12.x.
At Sybase, we used this machine configuration for the performance runs:
To achieve a fair comparison, we used the same IQ configuration in terms of resource and schema for Sybase IQ 15.x and Sybase IQ 12.x.
Click here to view the complete document (PDF)