Adding indexes for improving asset search
Indexes improve performance based on internal benchmarks and field engagement.
On the Asset Console of the Mid Tier interface, depending on the filters you commonly use, you might need to fine tune the performance of Smart IT. To improve performance, you can apply indexes to the fields listed in this topic, which might be found to underperform during asset searches.
You can create separate indexes on the fields listed in this topic. It is preferable to use BMC Atrium Class Manager for adding indexes on the fields pertaining to BMC.CORE:BMC_BaseElement. The AST:Attributes fields requires Developer Studio for creating indexes. Creating indexes by using BMC Atrium Class Manager is a convenient way, but it is not a mandatory method. You may still create indexes using Search performance measures, if they are available. Your preference depends on the availability and accessibility to these tools.
Indexes for improving asset search performance
In Oracle Case Insensitive environments, you can create the following indexes to improve performance in loading related assets on the view asset screen:
Form name | Field name and ID | Index type |
|---|---|---|
BMC.CORE:BMC_BaseElement | ReconciliationIdentity(C400129200), | Composite |
BMC.CORE:BMC_BaseRelationship | Destination.ReconciliationIdentity(C400131000), | Composite |
Indexes for searching assets by using Keyword
You can apply indexes to the fields listed in the following table:
Field name | Form name | Field name and ID |
|---|---|---|
AssetID | AST:Attributes | AssetID(210000000) |
Name | BMC.CORE:BMC_BaseElement | Name(200000020) |
Indexes for searching assets by using Scanned code
You can apply indexes to the fields listed in the following table:
Field name | Form name | Field name and ID |
|---|---|---|
TagNumber | AST:Attributes | TagNumber(260100004) |
SerialNumber | BMC.CORE:BMC_BaseElement | SerialNumber(200000001) |
Indexes for searching assets by using Type/Subtype
You can create composite indexes on the following fields:
Field name | Form name | Field name and ID |
|---|---|---|
DatasetId | BMC.CORE:BMC_BaseElement | DatasetId(400127400) |
ClassId | BMC.CORE:BMC_BaseElement | ClassId(400079600) |
Indexes for searching assets by using Product Category/Name
You can create composite indexes on the following fields:
Field name | Form name | Field name and ID |
|---|---|---|
Type | BMC.CORE:BMC_BaseElement | Type(200000004) |
Item | BMC.CORE:BMC_BaseElement | Item(200000005) |
Model | BMC.CORE:BMC_BaseElement | Model(240001002) |
Indexes for searching assets by using other available filters
Depending on the common search pattern followed at your site, you can create separate or composite indexes on the following fields:
Field name | Form name | Field name and ID |
|---|---|---|
Region | BMC.CORE:BMC_BaseElement | Region(200000012) |
SiteGroup | BMC.CORE:BMC_BaseElement | SiteGroup(200000007) |
Site | BMC.CORE:BMC_BaseElement | Site(260000001) |
Room | BMC.CORE:BMC_BaseElement | Room(260000005) |
Floor | AST:Attributes | Floor(260000004) |
Status | AST:Attributes | AssetLifecycleStatus(7) |
Manufacturer | BMC.CORE:BMC_BaseElement | ManufacturerName(240001003) |
Indexes for searching assets by using keywords
(Change request tickets only) You can create separate indexes for searching assets by using keywords in the default text field:
Field name | Form name | Field name and ID |
|---|---|---|
Name | BMC.CORE:BMC_BaseElement | Name(200000020) |
ManufacturerName | BMC.CORE:BMC_BaseElement | ManufacturerName(240001003) |
Model | BMC.CORE:BMC_BaseElement | Model(240001002) |