I have created a Select by Attributes query expression and saved it (.exp file). When I run this query as a new selection on my map layer I get 3924 selected of 11500. See below:
However, if clear my selection and then used the same saved expression as a Definition Query (By selecting the saved query in the Definition Query box) for the same map layer I get a different number of records selected. See below:
After running the Definition Query I'm only getting 2000 results.
Can anyone explain why the same query on the same data set would produce different output results?
Solved! Go to Solution.
After clicking on the Load All button I do get the correct number of records. Is there a reason why the default isn't to retrieve all the records? Perhaps an initial limit of retrieved records?
This behavior you are seeing has been around in various forms since ArcGIS 8.x, when working with enterprise geodatabase data. Are you working with file or enterprise geodatabase data?
This is just normal behaviour. While your dataset may be small and nothing to worry about, just imagine what would happen if ArcGIS would load a 100M records layer of 25GB file size stored in an enterprise geodatabase over your organization's network of 100Mbps... You would be waiting for at least 25000/(100/8)=2000 seconds, so close to 30 minutes / half an hour, before your attribute table would appear. And that assumes you will get the full 100Mbps, which you probably rarely will.
So pulling all records from a large database table is not something you want to customarily do.