Joining a spatial layer with Oracle SDE view only returning some records

Discussion created by on Mar 26, 2014
Latest reply on Mar 26, 2014 by vangelo-esristaff
I'm running SDE 9.1 on Oracle 10g. I have a spatial table with land parcel polygons and the other with some attribute data. The spatial table is indexed but the attribute data table is a view and is not. I do a join in Arcmap based on a parcel id and everything appears to work fine but it does not when you try to use more than a few hundred records.

In ArcMap 10.0, 10.1 and 10.2 only the first 300 records (out of 2300) are returned when the table is viewed.
In ArcMap 9.31 it works fine.

Does anyone know if there settings in ArcMap 10.x that control the number of records returned in a request or is this just an incompatibility between versions with ArcGIS.