In This Chapter

This chapter describes performance considerations associated with unfragmented tables and table fragments. It covers the following issues:

• Table placement on disk to increase throughput and reduce contention
• Space estimates for tables and blobpages
• Sbspace management
• Extents management
• Changes to tables that add or delete historical data
• Denormalization of the database to reduce overhead