Sybase IQ 12.7 includes functionality that will enhance loading and ease of data migration from operational systems and analytics including additional online analytical processing (OLAP) functions.
* Much like other niche vendors like Netezza, Sybase IQ can only provide strong performance in a limited set of analytic scenarios: When the number of columns in a table that is queried are limited. As the number of columns increases, the database must reassemble rows, which results in slower performance compared with a large query in a row-based system.
Unlike Oracle, Sybase has two different databases, one for OLTP (ASE) and one for DW (IQ), which complicates an organizationÃ¢â‚¬â„¢s infrastructure. This added complexity is the same as having Teradata or Netezza in addition to Oracle for OTLP.