Sybase IQ often works better with denormalized schemas common in data warehouse design. In a traditional relational database, normalization improves transaction processing by removing redundancy and improving consistency. In a data warehouse, especially a very large one, denormalization improves performance when processing queries against large amounts of data. See “Denormalizing for performance” in Performance and Tuning Guide.
