topic Re: Query Builder submits a execution for each attribute selection in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820145#M40971 I suspect this is going to be a tech support question. Thu, 23 Jun 2022 19:17:27 GMT Reeza 2022-06-23T19:17:27Z Query Builder submits a execution for each attribute selection https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820144#M40970 <P>When user is selecting a new atribute for aggregate functions while they are creating query, a new query is submitted to DBMS without run the step yet. That´s not make, because it is a huge data lake and for every click on query builder SAS Enteprise guide freezes and wait to response from the query. How to disable that ? It is a option should cause that ?&nbsp;</P><P>&nbsp;</P><P>SAS E. Guide 64 bit, 8.3&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Query_Guide.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/72703i0AACFBBC0DC12496/image-size/large?v=v2&amp;px=999" role="button" title="Query_Guide.png" alt="Query_Guide.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Query_hive.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/72704i7315B8D2F824963D/image-size/large?v=v2&amp;px=999" role="button" title="Query_hive.png" alt="Query_hive.png" /></span></P><P>&nbsp;</P> Thu, 23 Jun 2022 19:13:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820144#M40970 BigRider 2022-06-23T19:13:22Z Re: Query Builder submits a execution for each attribute selection https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820145#M40971 I suspect this is going to be a tech support question. Thu, 23 Jun 2022 19:17:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820145#M40971 Reeza 2022-06-23T19:17:27Z Re: Query Builder submits a execution for each attribute selection https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820256#M40977 <P>What happens if you go to Tools - Options - Query, and uncheck the option 'Validate query whenever changes are made'? Does that help?</P> Fri, 24 Jun 2022 14:36:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820256#M40977 jebjur 2022-06-24T14:36:52Z Re: Query Builder submits a execution for each attribute selection https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820333#M40978 <P>yes, It it is exactly this option which is causing this weird behavior.</P> Fri, 24 Jun 2022 22:04:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-submits-a-execution-for-each-attribute-selection/m-p/820333#M40978 BigRider 2022-06-24T22:04:52Z