topic Re: When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory? in QlikView https://community.qlik.com/t5/QlikView/When-you-execute-a-SQL-SELECT-Count-or-Count-Distinct-on-a/m-p/497594#M692654 <HTML><HEAD></HEAD><BODY><P>Count is done in the DB and then returned to QV.</P></BODY></HTML> Thu, 15 Aug 2013 14:28:13 GMT swuehl 2013-08-15T14:28:13Z When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory? https://community.qlik.com/t5/QlikView/When-you-execute-a-SQL-SELECT-Count-or-Count-Distinct-on-a/m-p/497593#M692653 <HTML><HEAD></HEAD><BODY><P>When executing a SQL SELECT COUNT x statement is the data loaded into memory and then counted or is the count done in the DB and then returned?</P></BODY></HTML> Thu, 15 Aug 2013 14:24:24 GMT https://community.qlik.com/t5/QlikView/When-you-execute-a-SQL-SELECT-Count-or-Count-Distinct-on-a/m-p/497593#M692653 2013-08-15T14:24:24Z Re: When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory? https://community.qlik.com/t5/QlikView/When-you-execute-a-SQL-SELECT-Count-or-Count-Distinct-on-a/m-p/497594#M692654 <HTML><HEAD></HEAD><BODY><P>Count is done in the DB and then returned to QV.</P></BODY></HTML> Thu, 15 Aug 2013 14:28:13 GMT https://community.qlik.com/t5/QlikView/When-you-execute-a-SQL-SELECT-Count-or-Count-Distinct-on-a/m-p/497594#M692654 swuehl 2013-08-15T14:28:13Z Re: When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory? https://community.qlik.com/t5/QlikView/When-you-execute-a-SQL-SELECT-Count-or-Count-Distinct-on-a/m-p/497595#M692655 <HTML><HEAD></HEAD><BODY><P>Only the result of the request is loaded in memory.</P><P></P><P>Consequently, a "select *" will load all data of the DB table while "select count(*)" will just the load the result of the count. </P></BODY></HTML> Thu, 15 Aug 2013 16:44:25 GMT https://community.qlik.com/t5/QlikView/When-you-execute-a-SQL-SELECT-Count-or-Count-Distinct-on-a/m-p/497595#M692655 matthieu_burel 2013-08-15T16:44:25Z