In the vast majority of cases, normalized schemas will produce faster and more efficient applications than denormalized schemas. There will be a few exceptions, on the order of three in ten thousand cases where a denormalized schema may produce one specific opeartion faster. These are typically in
Data Warehouse schemas, often used for building analytical cubes. If you can afford the...