Figure 4: The simple scan necessary with the denormalized lineitem relation performs much better than the four-way join necessary with the normalized schema.