DOMAIN INDEX (Sel: Default - Undefined)

1211
0
12-14-2016 07:43 PM
HiteshJilka
New Contributor III

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. 

0 Kudos
0 Replies