---
title: "Database indexes"
canonical: "https://docs.perspectium.com/space/helium/2113982/Database%20indexes"
format: markdown
---
<span style="color: #333333">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.</span>

<span style="color: #333333">If an index was not created when the application was installed in your ServiceNow instance, you can </span>[<span style="color: #333333">manually create an index</span>](https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/table-administration/task/t_CreateCustomIndex.html?title=Unique_Index)<span style="color: #333333">. </span>


| **Table** | **Type** | **Fields** |
| --- | --- | --- |
| <span style="color: #333333">PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message)</span> | composite, non-unique | <span style="color: #000000">State (state)</span><br><span style="color: #000000">Target Queue (u_target_queue)</span><br><span style="color: #000000">Created (sys_created_on)</span> |
| <span style="color: #333333">PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message)</span> | <span style="color: #333333">single, non-unique</span> | <span style="color: #000000">Sequence (u_sequence)</span> |
| PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message) | <span style="color: #333333">composite, non-unique</span> | <span style="color: #000000">Created (sys_created_on)</span><br><span style="color: #000000">Sequence (u_sequence)</span> |
| <span style="color: #333333">PSP In Message (psp_in_message)</span> | <span style="color: #333333">single, non-unique</span> | <span style="color: #000000">Created (sys_created_on)</span><br><span style="color: #000000">Name (name)</span><br><span style="color: #000000">Key (key)</span><br><span style="color: #000000">Sequence (u_sequence)</span> |
| <span style="color: #333333">PSP In Message (psp_in_message)</span> | <span style="color: #333333">single, non-unique</span> | <span style="color: #000000">State (state)</span> |
| <span style="color: #333333">PSP Log Message (u_psp_log_message)</span> | single, non-unique | <span style="color: #000000">Created (sys_created_on)</span> |
| PSP Log Message (u_psp_log_message) | composite, non-unique | <span style="color: #000000">Created (sys_created_on)</span><br><span style="color: #000000">Type (u_type)</span> |
| PSP Properties (u_psp_properties) | <span style="color: #333333">single, non-unique</span> | <span style="color: #000000">Name (u_name)</span> |
| Replicator Configurations (psp_replicate_conf) | single, non-unique | <span style="color: #000000">Active (active)</span><br><span style="color: #000000">Direction (sync_direction)</span><br><span style="color: #000000">Table (table_name)</span> |
| Receipt (u_psp_receipt) | <span style="color: #333333">single, non-unique</span> | <span style="color: #000000">Share Record (u_share_record)</span> |
| Receipt (u_psp_receipt) | <span style="color: #333333">single, non-unique</span> | <span style="color: #333333">Source Record (u_source_record)</span> |
| Receipt (u_psp_receipt) | <span style="color: #333333">single, non-unique</span> | <span style="color: #000000">Created (sys_created_on)</span> |
| Receipt (u_psp_receipt) | <span style="color: #333333">composite, non-unique</span> | <span style="color: #000000">Delivery Status (u_delivery_status)</span><br><span style="color: #000000">Is Retrying (u_is_retrying)</span> |
| Receipt (u_psp_receipt) | <span style="color: #333333">composite, non-unique</span> | <span style="color: #000000">Type (u_type)</span><br><span style="color: #000000">Batch Source (u_batch_source)</span><br><span style="color: #000000">Batch Type (u_batch_type)</span> |