Important! You must regularly collect statistics for all tables, columns and indexes in the CA DataMinder database. Failure to do so may significantly slow down searches for captured data.
For optimum performance, indexes require additional maintenance. The most important aspect of index maintenance is statistics. Both Oracle and SQL Server use a number of statistics, including ‘column value distribution’ statistics, to determine the suitability of an index for a particular database query. You must keep these statistics up to date to verify the query processor operates reliably. See your database documentation for information about maintaining database statistics.
|
Copyright © 2014 CA.
All rights reserved.
|
|