Sybase IQ provides benefits that support the interactive approach to decision support including:
Intelligent query processing: Sybase IQ uses index-only access plans to process only the data needed to satisfy any type of query.
Truly interactive ad hoc query performance on a uniprocessor as well as on parallel systems. An ad hoc query is one about which the system has no prior knowledge and for which no explicit tuning is required. Ad hoc queries are distinguished from standard or production reports, where only pre-defined variables, such as dates, are used to generate pre-defined reports on a regular basis.
Multiplex capability for managing large query loads in a multi-server configuration. For more information, see the System Administration Guide: Volume 1.
Fully-flexible schema support.
Efficient query execution without query-specific tuning by the System Administrator (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 I/O.
