Home

	Expand Search

Performance and Tuning Guide Volumes 1 - 3 (Online Only)

Chapter 14 Setting Space Management Properties

Chapter 14

Setting Space Management Properties

Setting space management properties can help reduce the amount of maintenance work required to maintain high performance for tables and indexes.

Reducing index maintenance

Advantages of using fillfactor

Disadvantages of using fillfactor

Setting fillfactor values

fillfactor examples

Use of the sorted_data and fillfactor options

Reducing row forwarding

Default, minimum, and maximum values for exp_row_size

Specifying an expected row size with create table

Adding or changing an expected row size

Setting a default expected row size server-wide

Displaying the expected row size for a table

Choosing an expected row size for a table

Conversion of max_rows_per_page to exp_row_size

Monitoring and managing tables that use expected row size

Leaving space for forwarded rows and inserts

Extent allocation operations and reservepagegap

Specifying a reserve page gap with create table

Specifying a reserve page gap with create index

Changing reservepagegap

reservepagegap examples

Choosing a value for reservepagegap

Monitoring reservepagegap settings

reservepagegap and sorted_data options to create index

Using max_rows_per_page on allpages-locked tables

Reducing lock contention

Indexes and max_rows_per_page

select into and max_rows_per_page

Applying max_rows_per_page to existing data