Scale-Up and Scale-Out Performance Features

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.
• Tiered High Group Index Structure
  New tiered High Group (HG) index structure decouples load performance from HG index size.
• NBit Dictionary Compression
  Continuous NBit dictionary compression replaces 1, 2, 3 byte dictionary compression in the initial 16.0 version. 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.