AnsweredAssumed Answered

DOMAIN INDEX (Sel: Default - Undefined)

Question asked by jilkahitesh on Dec 14, 2016

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. 

 

Outcomes