Scale up features take advantage of multiple cores and high parallelism in a single
servers to provide high load and query performance. Multiplex and logical servers scale-out
to multiple servers to improve query performance.
Fully Parallel Bulk Load
New load engine effectively scales data loads to make use of all additional hardware.
NBit Dictionary Compression
Continuous NBit dictionary compression replaces 1, 2, 3 byte dictionary compression. All datatypes except LOB (character and binary) and BIT datatypes may be NBit columns.
Hash Partitioning
Hash Partitioning reduces resource usage and internode communication.
Data Affinity
Data affinity accesses cached data to boost query performance in multiplex servers.
Non-Partitioned Query Scale-Out
For non-partitioned data, new JOIN and GROUP BY algorithms reduce the amount of intermediate results that are exchanged during distributed query execution.
Cache Ejection
Caches are handled more efficiently with multiple writers in SAP Sybase IQ Multiplex.
Login Redirection
Logical servers can redirect connections at login time.
LDAPUA
LDAP user authentication (LDAPUA) allows client applications to send user names and passwords to SAP Sybase IQ for authentication by an LDAP server.