This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
BMC Remedy AR System Server
The Asset Advanced Search needs some indexing support or something that will make the turnaround quicker
LP: BMC Remedy AR System Server
Issue Summary: The Asset Advanced Search needs some indexing support or something that will make the turnaround quicker
1. Analyzed the log using log analyzer and found long running API calls on "AST:Relation_BaseElement_Locale form"
2. "AST:Relation_BaseElement_Locale" is a join form of AST:BaseElement and SHR:SchemaNames regular forms
3. Suggested to create indexes on below fields on "AST:BaseElement" regular form to improve search performance
4. It improved Asset Advanced Search performance
- BMC Remedy AR System Server