Updating Statistics in a Tablespace

How To

As part of a strategy to optimize the performance of a tablespace, you can update the statistics of a tablespace. The Sample Ratio value denotes the percentage of data in the object that will be used to calculate and update the statistics of the object. If nothing is entered, the default ratio is 1. The sample ratio and the amount of data in the database determine how long it takes to update statistics.


Related topic:

Altering a Tablespace