---
title: "Database indexes"
canonical: "https://docs.perspectium.com/space/gold/1266514/Database%20indexes"
format: markdown
---
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) Similar topics Contact Perspectium Support US:  1 888 620 8880 UK:  44 208 068 5953 support@perspectium.com