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