Design Matters

In the Introduction, we noted that optimization begins during requirements gathering and design. To be precise, it starts with system design, including the database design, but it is impossible to come up with the right design unless we invest time in gathering information about the objects that should be present in the database. In this chapter, we will discuss a variety of design options and will show how design decisions can impact performance.