Table performance considerations
Some performance issues are associated with unfragmented tables and table fragments.
Issues include:
- Table placement on disk to increase throughput and reduce contention
- Space estimates for tables, blobpages, sbspaces, and extents
- Changes to tables that add or delete historical data
- Denormalization of the database to reduce overhead