Enterprise Edition Home | Express Edition Home | Previous Page | Next Page  

Table Performance Considerations

In This Chapter
Placing Tables on Disk
Isolating High-Use Tables
Placing High-Use Tables on Middle Partitions of Disks
Using Multiple Disks
Using Multiple Disks for a Dbspace
Using Multiple Disks for Logical Logs
Spreading Temporary Tables and Sort Files Across Multiple Disks
Backup-and-Restore Considerations
Improving Performance for Nonfragmented Tables and Table Fragments
Estimating Table Size
Estimating Data Pages
Estimating Tables with Fixed-Length Rows
Estimating Tables with Variable-Length Rows
Selecting an Intermediate Value for the Size of the Table
Estimating Pages That Simple Large Objects Occupy
Storing Simple Large Objects in the Tblspace or a Separate Blobspace
Estimating Tblspace Pages for Simple Large Objects
Managing the Size of First and Next Extents for the tblspace tblspace
Managing Sbspaces
Estimating Pages That Smart Large Objects Occupy
Estimating the Size of the Sbspace and Metadata Area
Sizing the Metadata Area Manually for a New Chunk
Improving Metadata I/O for Smart Large Objects
Monitoring Sbspaces
Using oncheck -cS
Using oncheck -pe
Using oncheck -pS
Using onstat -g smb
Changing Storage Characteristics of Smart Large Objects
Altering Smart-Large-Object Columns
Managing Extents
Choosing Table Extent Sizes
Extent Sizes for Tables in a Dbspace
Extent Sizes for Table Fragments
Extent Sizes for Smart Large Objects in Sbspaces
Monitoring Active Tblspaces
Managing Extents
Considering the Upper Limit on Extents
Checking for Extent Interleaving
Eliminating Interleaved Extents
Reclaiming Unused Space Within an Extent
Changing Tables
Loading and Unloading Tables
Advantages of Logging Tables
Advantages of Nonlogging Tables
Dropping Indexes for Table-Update Efficiency
Attaching or Detaching Fragments
Altering a Table Definition
Slow Alter
In-Place Alter
Fast Alter
Denormalizing the Data Model to Improve Performance
Shortening Rows
Expelling Long Strings
Using VARCHAR Columns
Using TEXT Data
Moving Strings to a Companion Table
Building a Symbol Table
Splitting Wide Tables
Division by Bulk
Division by Frequency of Use
Division by Frequency of Update
Costs of Companion Tables
Redundant Data
Adding Redundant Data
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]