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

3729
0
08-22-2014 01:00 PM
DerekBorum
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