Hello,
Sync operation is taking lots of time and when I see at execution plan of query fired within it shows most of time spend is at Domain Index.
-------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------------------------
| 9 | DOMAIN INDEX (Sel: Default - Undefined) | A157_IX1 | | | 18E (0)|999:59:59 |
From support, found below note:
If (Sel: Default - Undefined) is reported it may indicate that there was an error generating statistics, or that the operator has been disassociated from the statistical type, such as the st_envintersects operator.
I tried to gathered STATS and rebuilt index but it doesn't improve the sync time.
Would anyone please help on this.
