Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
Count is done in the DB and then returned to QV.
Only the result of the request is loaded in memory.
Consequently, a "select *" will load all data of the DB table while "select count(*)" will just the load the result of the count.