topic DOMAIN INDEX (Sel: Default - Undefined) in Data Management Questions https://community.esri.com/t5/data-management-questions/domain-index-sel-default-undefined/m-p/451850#M25818 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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.&nbsp;</P><P></P><P>-------------------------------------------------------------------------------------------------------------------------<BR />| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |<BR />-------------------------------------------------------------------------------------------------------------------------<BR />| 9 | DOMAIN INDEX (Sel: Default - Undefined) | A157_IX1 | | | 18E (0)|999:59:59 |</P><P></P><P>From support, found below note:</P><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff;">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.</SPAN></P><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff;">I tried to gathered STATS and rebuilt index but it doesn't improve the sync time.</SPAN></P><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff;">Would anyone please help on this.&nbsp;</SPAN></P><P></P></BODY></HTML> Thu, 15 Dec 2016 03:43:09 GMT HiteshJilka 2016-12-15T03:43:09Z DOMAIN INDEX (Sel: Default - Undefined) https://community.esri.com/t5/data-management-questions/domain-index-sel-default-undefined/m-p/451850#M25818 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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.&nbsp;</P><P></P><P>-------------------------------------------------------------------------------------------------------------------------<BR />| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |<BR />-------------------------------------------------------------------------------------------------------------------------<BR />| 9 | DOMAIN INDEX (Sel: Default - Undefined) | A157_IX1 | | | 18E (0)|999:59:59 |</P><P></P><P>From support, found below note:</P><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff;">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.</SPAN></P><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff;">I tried to gathered STATS and rebuilt index but it doesn't improve the sync time.</SPAN></P><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff;">Would anyone please help on this.&nbsp;</SPAN></P><P></P></BODY></HTML> Thu, 15 Dec 2016 03:43:09 GMT https://community.esri.com/t5/data-management-questions/domain-index-sel-default-undefined/m-p/451850#M25818 HiteshJilka 2016-12-15T03:43:09Z