Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory?

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory?

Count is done in the DB and then returned to QV.

2 Replies
MVP
MVP

Re: When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory?

Count is done in the DB and then returned to QV.

matthieu_burel
New Contributor III

Re: When you execute a SQL SELECT Count or Count Distinct on a database is the data still loaded into memory?

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.

Community Browser