The gdb_temp_user_ids table created during synchronization of replica involving geometric network datasets does not have any indexes and results in performance issues with the synchronization process.

Workaround

Create the gdb_temp_user_ids table in advance and create an index on it.

• create table gdb_temp_user_ids(user_id NUMBER(38));
• create index gdb_temp_user_ids_idx on gdb_temp_user_ids(user_id);

Note: The replication runs at the usual time.

Schritte zur Reproduzierung