|
If your database contains . . .
|
Then you should . . .
|
|
Many large or frequently updated tables
|
Create a storage area for each table. This will give you easier administration and better performance.
|
|
Many small tables
|
Create storage areas to represent a distinct subject (for example Sales, Inventory, etc.) and assign related tables to that storage area. This will give you easier administration.
|
|
A mixture of large and small tables
|
Combine the above two strategies.
|
|
Many indexes for large or frequently updated tables
|
Create a storage area for each index. This will give you flexibility in administration, and the potential for better performance.
|
|
Many of small indexes
|
Create storage areas representing a distinct subject for these indexes. This will give you easier administration.
|