IBM FileNet P8, Version 5.2.1            

Periodic statistics gathering [guideline]

The generation of correct query execution plans relies on up-to-date statistics.

Restriction: Oracle statistics in some cases are known to give incorrect query execution plans, even when the right indexes are present. For more information, see technote Database indexes are sometimes not used by the Oracle optimizer thus causing full table scans and slow running queries.

For database tables that contain millions of rows, frequent statistics runs might not be necessary if the distribution does not change much.



Last updated: March 2016
p8ppt287.htm

© Copyright IBM Corporation 2016.