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 |