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:
- 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.
- 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?