VLDB Manageability and Performance
Constraints
Table availability:
Large tables are more vulnerable to disk failure
It is too costly to have a large table inaccessible for
hours due to recovery
Large table manageability
They take to long to be loaded
Indexes take too long to be built
Partial deletes take hours
Performance considerations
Large table and index scans are costly
Scanning a subset improves performance