Previous Topic: Step 2: Review the Physical Database ModelNext Topic: Potential Design Flaws


Calculating I/Os

As you trace the flow of each business transaction, you should calculate the number of input/output operations that will be performed. The I/O calculation for a business transaction depends on several factors. These factors include the order in which entities are accessed, the location mode of each entity accessed, the types of indexes (if any) used to access the data, and the way entities are clustered in the database.

See Chapter 12, "Refining the Database Design" for instructions on how to estimate the number of I/Os for a transaction.