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


TableTypeFields
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-uniqueSequence (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-uniqueState (state)
PSP Log Message (u_psp_log_message)single, non-uniqueCreated (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-uniqueName (u_name)
Replicator Configurations (psp_replicate_conf)single, non-unique

Active (active)

Direction (sync_direction)

Table (table_name)

Receipt (u_psp_receipt)single, non-uniqueShare Record (u_share_record)
Receipt (u_psp_receipt)single, non-uniqueSource Record (u_source_record)
Receipt (u_psp_receipt)single, non-uniqueCreated (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-uniqueTarget Application (u_target_app)
Table Compares (u_psp_table_compares)single, non-uniqueScheduled (u_scheduled)
Table Compares (u_psp_table_compares)single, non-uniqueTarget 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)