0006104: Add indexes to sym_outgoing_batch - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0006104	SymmetricDS	Improvement	public	2023-11-08 19:36	2023-11-10 21:00

Reporter	emiller	Assigned To	emiller
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.15.0
Target Version	3.15.1	Fixed in Version	3.15.1

Summary	0006104: Add indexes to sym_outgoing_batch
Description	The following 2 indexes have been found to improve performance when added to sym_outgoing_batch on a SQL Server database: CREATE INDEX [NCLIX_sym_outgoing_batch_channel_id_status] ON [sym_outgoing_batch] ([channel_id], [status]) WITH (FILLFACTOR=80, ONLINE =ON); CREATE INDEX [NCLIX_sym_outgoing_batch_node_id_channel_id_summary_Includes] ON [sym_outgoing_batch] ([node_id], [channel_id], [summary]) INCLUDE ([status], [create_time], [byte_count], [data_row_count], [load_millis]) WITH (FILLFACTOR=80, ONLINE =ON); It would be good to add these indexes to sym_outgoing_batch by default.
Tags	schema

Date Modified	Username	Field	Change
2023-11-08 19:36	emiller	New Issue
2023-11-08 19:36	emiller	Status	new => assigned
2023-11-08 19:36	emiller	Assigned To	=> emiller
2023-11-08 19:36	emiller	Tag Attached: schema
2023-11-10 20:04	emiller	Status	assigned => resolved
2023-11-10 20:04	emiller	Resolution	open => fixed
2023-11-10 20:04	emiller	Fixed in Version	=> 3.15.1
2023-11-10 20:04	emiller	Note Added: 0002397
2023-11-10 21:00		Changeset attached	=> SymmetricDS 3.15 3104ed53
2023-11-14 21:10	admin	Status	resolved => closed

SymmetricDS: 3.15 3104ed53 2023-11-10 20:03:11 evan-miller-jumpmind Details Diff	0006104: Added channel_id to index on sym_outgoing_batch		Affected Issues 0006104
	mod - symmetric-core/src/main/resources/symmetric-schema.xml		Diff File

emiller 2023-11-10 20:04 developer ~0002397	We looked at the various queries that SymmetricDS runs on sym_outgoing_batch and decided it would be best to add the channel_id column to one of the existing indexes instead of adding 2 more.