Select to view content in your preferred language

Indexes in Oracle table aren't recognized when viewing table in ArcMap

08-22-2014 01:00 PM
New Contributor

Hello all,


I have a table sitting in an Oracle database that has an index on the key field.  I can open ArcMap and make a data connection to the table to see the data but the index isn't recognized by ArcMap.  There are 2 indicators that the index isn't being recognized:


  1. 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.
  2. 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.


Anyone know how to fix this and make ArcMap recognize the index?

0 Kudos
0 Replies