Schema Design

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.