Joining "Indexed" SDE Feature to Oracle Table : Join Tool Not Recognizing Index

03-11-2014 03:16 PM
by Anonymous User
Not applicable
Original User: ZJPierce

Hello All,

I am trying to Join an SDE layer in my mxd to an Oracle Table.

The SDE Feature is called JOINT, and the Oracle Table is called ESRI_ELEV.

I have created a unique index on the JOINT SDE feature, on the field "NUMBER1". However, when I am inside my MXD, and am in the Join Data dialogue, I get the "Message From Join" dialogue box that says: [ATTACH=CONFIG]32125[/ATTACH]. I am joining the NUMBER_1 field to EVENT_ID in the oracle ESRI_ELEV table.

From that message, it seems Arc Map is saying the SDE Number1 field is not indexed, when it is : [ATTACH=CONFIG]32126[/ATTACH].

Is there something I am missing, or I am reading this message incorrectly?

0 Kudos
2 Replies
Occasional Contributor III
what about "ESRI_ELEV" Oracle table does the column have an index on it ?
0 Kudos
by Anonymous User
Not applicable
Original User: vangelo

Is the NUMBER1 field a discrete numeric type (does it map to an integer)?  Joins on continuous numeric types (floating point) are less than useful. -V
0 Kudos