AnsweredAssumed Answered

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

Question asked by mechengr2010 on Aug 22, 2014

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?

Outcomes