How to create a custom index.
|Article:HOWTO83874|||||Created: 2013-02-26|||||Updated: 2013-02-26|||||Article URL http://www.symantec.com/docs/HOWTO83874|
Understanding and implementing a custom index on a heavily read CMDB table can greatly improve product performance. This performance gain has a tradeoff. SQL queries using the indexed field will resolve much quicker than a non-indexed field. There are a few ways of determining potential new index. Here is one SQL statement method for determining the tables and fields that have taken the longest for a SQL server to return results:
Article URL http://www.symantec.com/docs/HOWTO83874