topic Re: Why Does Definition Query and Select by Attributes Gives Me Different Results in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715502#M31510 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 06 Jun 2018 17:30:16 GMT KellyAllen2 2018-06-06T17:30:16Z Why Does Definition Query and Select by Attributes Gives Me Different Results https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715500#M31508 <HTML><HEAD></HEAD><BODY><P>I have created a Select by Attributes query&nbsp; 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:</P><P><IMG __jive_id="410639" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/410639_pastedImage_1.png" /></P><P>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)&nbsp; for the same map layer I get a different number of records selected. See below:</P><P><IMG __jive_id="410640" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/410640_pastedImage_2.png" /></P><P></P><P>After running the Definition Query I'm only getting 2000 results.</P><P>Can anyone explain why the same query on the same data set would produce different output results?&nbsp;</P></BODY></HTML> Tue, 05 Jun 2018 20:23:00 GMT https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715500#M31508 KellyAllen2 2018-06-05T20:23:00Z Re: Why Does Definition Query and Select by Attributes Gives Me Different Results https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715501#M31509 <HTML><HEAD></HEAD><BODY><P>Hit the Load All button, how many records are retrieved?</P></BODY></HTML> Tue, 05 Jun 2018 21:41:01 GMT https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715501#M31509 JoshuaBixby 2018-06-05T21:41:01Z Re: Why Does Definition Query and Select by Attributes Gives Me Different Results https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715502#M31510 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 06 Jun 2018 17:30:16 GMT https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715502#M31510 KellyAllen2 2018-06-06T17:30:16Z Re: Why Does Definition Query and Select by Attributes Gives Me Different Results https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715503#M31511 <HTML><HEAD></HEAD><BODY><P>This behavior you are seeing has been around in various forms since ArcGIS 8.x, when working with enterprise geodatabase data.&nbsp; Are you working with file or enterprise geodatabase data?</P></BODY></HTML> Wed, 06 Jun 2018 18:55:12 GMT https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715503#M31511 JoshuaBixby 2018-06-06T18:55:12Z Re: Why Does Definition Query and Select by Attributes Gives Me Different Results https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715504#M31512 <HTML><HEAD></HEAD><BODY><P>It is a file geodatabase. I've not worked with enterprise geodatabase data.</P></BODY></HTML> Wed, 06 Jun 2018 19:23:45 GMT https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715504#M31512 KellyAllen2 2018-06-06T19:23:45Z Re: Why Does Definition Query and Select by Attributes Gives Me Different Results https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715505#M31513 <HTML><HEAD></HEAD><BODY><P>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&nbsp;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.</P><P></P><P>So pulling all records from a large database table is not something you want to customarily do.</P></BODY></HTML> Thu, 07 Jun 2018 13:57:40 GMT https://community.esri.com/t5/arcgis-pro-questions/why-does-definition-query-and-select-by-attributes/m-p/715505#M31513 MarcoBoeringa 2018-06-07T13:57:40Z