topic Indexes in Oracle table aren't recognized when viewing table in ArcMap in Data Management Questions https://community.esri.com/t5/data-management-questions/indexes-in-oracle-table-aren-t-recognized-when/m-p/192581#M10939 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I have a table sitting in an Oracle database that has an index on the key field.&nbsp; I can open ArcMap and make a data connection to the table to see the data but the index isn't recognized by ArcMap.&nbsp; There are 2 indicators that the index isn't being recognized:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><OL><LI>When I look at the attribute table for the oracle table the column header for the key field doesn't have a * which indicates and index.</LI><LI>When I attempt to join this table to another table I get a warning notice that performance may be slow since an index isn't on the oracle table.</LI></OL><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Anyone know how to fix this and make ArcMap recognize the index?</P></BODY></HTML> Fri, 22 Aug 2014 20:00:07 GMT DerekBorum 2014-08-22T20:00:07Z Indexes in Oracle table aren't recognized when viewing table in ArcMap https://community.esri.com/t5/data-management-questions/indexes-in-oracle-table-aren-t-recognized-when/m-p/192581#M10939 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I have a table sitting in an Oracle database that has an index on the key field.&nbsp; I can open ArcMap and make a data connection to the table to see the data but the index isn't recognized by ArcMap.&nbsp; There are 2 indicators that the index isn't being recognized:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><OL><LI>When I look at the attribute table for the oracle table the column header for the key field doesn't have a * which indicates and index.</LI><LI>When I attempt to join this table to another table I get a warning notice that performance may be slow since an index isn't on the oracle table.</LI></OL><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Anyone know how to fix this and make ArcMap recognize the index?</P></BODY></HTML> Fri, 22 Aug 2014 20:00:07 GMT https://community.esri.com/t5/data-management-questions/indexes-in-oracle-table-aren-t-recognized-when/m-p/192581#M10939 DerekBorum 2014-08-22T20:00:07Z