Sybase IQ supports an interactive approach to decision support that includes:
Intelligent query processing that use index-only access plans to process any type of query.
Ad hoc query performance on uniprocessor and parallel systems.
Multiplex capability for managing large query loads in a multi-server configuration.
Fully-flexible schema support.
Efficient query execution without query-specific tuning under most circumstances.
Fast initial and incremental loading.
Fast aggregations, counts, comparisons of data.
Parallel processing optimized for multi-user environments.
Stored procedures.
Increased productivity due to reduced query time.
Entire database and indexing stored in less space than raw data.
Reduced input/output (I/O).
