|
|
|
Your CA DLP database automatically includes a set of base indexes. These were chosen for their ability to speed up common queries such as captured data searches based on event, trigger or user properties. To ensure optimum performance, these indexes must be properly maintained.
For SQL Server databases, you must regularly defragment the database pages that hold index data and keep your database statistics up to date. For full details about maintaining indexes, see your SQL Server documentation.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |