Table index overview

These are the tables and columns that are used to query data when running the different functions. Creating indexes on them will help with performance on large data sets.

Table

Column

Function used

Must index be added?

cmdb_ci_computer

x_snsab_snow_sam_i_snow_computer_id

findDevice

Yes

cmdb_ci_spkg

x_snsab_snow_sam_i_snow_application_id

findApplication

Yes

cmdb_ci_disk

snow_computer_id

findByComputerId

Implicit

cmdb_ci_hyper_v_instance

object_id

-

Yes

cmdb_ci_hyper_v_instance

x_snsab_snow_sam_i_virtual_machine_id

-

Yes

cmdb_ci_network_adapter

snow_computer_id

findByComputerId

Implicit

cmdb_ci_network_adapter

name

-

N/A

cmdb_rel_ci

snow_checksum

-

Yes

cmdb_ci_vcenter

name

-

N/A

cmdb_ci_vmware_instance

object_id

-

Yes

cmdb_ci_vmware_instance

x_snsab_snow_sam_i_virtual_machine_id

-

Yes

cmdb_software_instance

x_snsab_snow_sam_i_snow_computer_id

findSoftwareInstance

Yes

cmdb_software_instance

x_snsab_snow_sam_i_snow_application_id

findSoftwareInstance

Yes