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

Copyright© 2018 HCL Technologies Limited