Sample Layout When Performance Is Highest Priority

Figure 51 shows a disk layout optimized for performance. This disk layout uses the following strategies to improve performance:

• Migration of the logical log from the rootdbs dbspace to a dbspace on a separate disk

  This strategy separates the logical log and the physical log and reduces contention for the root dbspace.

• Location of the two tables that undergo the highest use in dbspaces on separate disks

  Neither of these disks stores the logical log or the physical log. Ideally you could store each of the items and orders tables on a separate high-performance disk. However, in the present scenario, this strategy is not possible because one of the high-performance disks is needed to store the very large cust_calls table (the other two disks are too small for this task).

Figure 51. Disk Layout Optimized for Performance