To improve performance, database indexes have been added to Perspectium's tables in ServiceNow. These indexes are included as part of the application and are documented below.
If an index was not created when the application was installed in your ServiceNow instance, you can manually create an index.
| Table | Type | Fields |
|---|---|---|
| PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message) | composite, non-unique | State (state) Target Queue (u_target_queue) Created (sys_created_on) |
| PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message) | single, non-unique | Sequence (u_sequence) |
| PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message) | composite, non-unique | Created (sys_created_on) Sequence (u_sequence) |
| PSP In Message (psp_in_message) | single, non-unique | Created (sys_created_on) Name (name) Key (key) Sequence (u_sequence) |
| PSP In Message (psp_in_message) | single, non-unique | State (state) |
| PSP Log Message (u_psp_log_message) | single, non-unique | Created (sys_created_on) |
| PSP Log Message (u_psp_log_message) | composite, non-unique | Created (sys_created_on) Type (u_type) |
| PSP Properties (u_psp_properties) | single, non-unique | Name (u_name) |
| Replicator Configurations (psp_replicate_conf) | single, non-unique | Active (active) Direction (sync_direction) Table (table_name) |
| Receipt (u_psp_receipt) | single, non-unique | Share Record (u_share_record) |
| Receipt (u_psp_receipt) | single, non-unique | Source Record (u_source_record) |
| Receipt (u_psp_receipt) | single, non-unique | Created (sys_created_on) |
| Receipt (u_psp_receipt) | composite, non-unique | Delivery Status (u_delivery_status) Is Retrying (u_is_retrying) |
| Receipt (u_psp_receipt) | composite, non-unique | Type (u_type) Batch Source (u_batch_source) Batch Type (u_batch_type) |
| Table Compares (u_psp_table_compares) | single, non-unique | Target Application (u_target_app) |
| Table Compares (u_psp_table_compares) | single, non-unique | Scheduled (u_scheduled) |
| Table Compares (u_psp_table_compares) | single, non-unique | Target Key (u_target_key) |
| Table Compares (u_psp_table_compares) | composite, non-unique | Target Application (u_target_app) Scheduled (u_scheduled) |
| Table Compares (u_psp_table_compares) | composite, non-unique | Target Application (u_target_app) Scheduled (u_scheduled) Target Key (u_target_key) |