Better treat everything from low level, start by one Class, ensure the legacy index in regular form, then upgrade to 8.1 and check the class-index in the new regular form or join.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad Esser Sent: Thursday, April 18, 2013 4:33 AM To: [email protected] Subject: CMDB 8.1 Index on Name Field ** Hello, Does anyone have a loaded 8.1 CMDB that can advise me on an indexing question? Our current production CMDB is 2.1 and we are moving to 8.1. In 2.1, I had to add an index on the Name field on base element to make searches tolerable for users. I see that 8.1 does not have an index on the name field either, and figure I'm going to have to add it. We haven't loaded all of our CIs yet, so I can't test that aspect myself. Before I add the index, I wanted to make sure I'm not missing some new feature or something else that BMC might have done to improve performance when searching by CI name. Have you indexed the Name field, and if not, how's performance when searching by name (and how many rows/CIs do you have)? We have about 750,000 CIs. The database is SQL Server and the AR Servers are Windows. The full ITSM suite is installed. Thanks, Thad _ARSlist: "Where the Answers Are" and have been for 20 years_ The information in this email may contain confidential material and it is intended solely for the addresses. Access to this email by anyone else is unauthorized. If you are not the intended recipient, please delete the email and destroy any copies of it, any disclosure, copying, distribution is prohibited and may be considered unlawful. Contents of this email and any attachments may be altered, Statement and opinions expressed in this email are those of the sender, and do not necessarily reflect those of Saudi Telecommunications Company (STC). _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
