Sybase IQ 15.3 extends the performance and scalability of multiplexes by leveraging the resources of multiple nodes.
Sybase IQ 15.3 includes these features:
Distributed query processing – provides a core set of distributable query operators which makes most queries distributable so they benefit from multinode scaling. Query distribution occurs automatically based on the server and multiplex configuration.
Logical servers – allows a subset of compute resources (multiplex servers) to be grouped together and presented to the end user as a logical entity.
Parallel operator support – provides additional parallelization and distribution support, thus improving performance and scalability of queries. To the existing set of parallelizable operators, this feature adds: sorted IN subquery, right outer hash join, OLAP (partition by), insert select, NLPD, and small-to-midsize queries.
Shared temporary dbspace – provides a new built-in dbspace to store temporary on-disk structures for distributed query processing.
The procedure for adding files to IQ_SHARED_TEMP has changed. The new procedure is described in Multiplex Transactions > DDL Commands > Dbspace Updates in Multiplex > Updates on IQ_SHARED_TEMP > Adding Dbfiles to Shared Dbspaces.
Multiplex interprocess communication (MIPC) – provides inter-node communication to support distributed query processing and high availability.