User Tools

Site Tools


replicator_optimization

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
replicator_optimization [2019/01/10 17:54]
robyn.lin
replicator_optimization [2019/05/08 17:16] (current)
timothy.pike [ServiceNow]
Line 28: Line 28:
 | PSP Out Message tables (psp_out_message,​ u_psp_attachment_out_message,​ u_psp_audit_out_message,​ u_psp_observer_out_message) ​ | psp_out_query3| 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) ​ | psp_out_query3| 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) ​ | psp_out_query4| composite, non-unique| Created (sys_created_on) \\ 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) ​ | psp_out_query4| composite, non-unique| Created (sys_created_on) \\ Sequence (u_sequence)|
-| PSP In Message (psp_in_message) ​   | psp_in_query ​ | single, non-unique ​  | Created (sys_created_on)|+| PSP In Message (psp_in_message) ​   | psp_in_query ​ | single, non-unique ​  | Created (sys_created_on), name, key, u_sequence|
 | PSP In Message (psp_in_message) ​   | psp_in_query2 | single, non-unique ​  | State (state)| | PSP In Message (psp_in_message) ​   | psp_in_query2 | single, non-unique ​  | State (state)|
 | PSP Log Message (u_psp_log_message)| psp_log_query | single, non-unique ​  | Created (sys_created_on)| | PSP Log Message (u_psp_log_message)| psp_log_query | single, non-unique ​  | Created (sys_created_on)|
 | PSP Log Message (u_psp_log_message)| psp_log_query2| composite, non-unique| Created (sys_created_on) \\ Type (u_type)| | PSP Log Message (u_psp_log_message)| psp_log_query2| composite, non-unique| Created (sys_created_on) \\ Type (u_type)|
-| PSP Properties (u_psp_properties)| ​ u_psp_properties_u_name | single, non-unique ​  | Name (u_name)|+| PSP Properties (u_psp_properties)| ​ u_psp_properties_u_name | single, non-unique ​  | Name (u_name) ​
 +| PSP Replicate Conf (u_psp_replicate_conf) | u_psp_replicate_conf | single, non-unique | active, sync_direction,​ table_name ​|
 ==== Sharing Instance ==== ==== Sharing Instance ====
  
replicator_optimization.txt · Last modified: 2019/05/08 17:16 by timothy.pike