I would add an index on the GUID field, which stores the instanceId of the CI This enables faster lookups when queries the audit record for a specific CI
Guillaume ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of Ranjith [[email protected]] Sent: Wednesday, February 24, 2010 10:13 PM To: [email protected] Subject: Index on CMDB:DefaultAuditLog ** Dear Listers, We are on ITSM 7.1 and are wondering if any of you have added index on the CMDB:DefaultAuditLog table. Thanks, Ranjith Kariminlla _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
