topic AW:query works too long in QlikView https://community.qlik.com/t5/QlikView/query-works-too-long/m-p/223741#M76223 <HTML><HEAD></HEAD><BODY><P>Thats a database problem. You need an db-index on customerdocumentid and customernumber, then it should work.</P><P></P><P>Greetings Alex:)</P></BODY></HTML> Wed, 27 Jan 2010 11:41:19 GMT 2010-01-27T11:41:19Z query works too long https://community.qlik.com/t5/QlikView/query-works-too-long/m-p/223740#M76222 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>I have table CUSTOMERDOCUMENT with fields customerdocumentid, customernumber, expirydate, documenttype</P><P>I want to find max(customerdocumentid) for each customernumber and i'm using query:</P><P>SELECT customernumber, documenttype, expirydate FROM CUSTOMERDOCUMENT WHERE customerdocumentid IN (SELECT max(customerdocumentid) from customerdocument as cd where cd.customernumber=customernumber);</P><P>In table is only 100000 rows but the query works an hour or even longer.</P><P>Is it possible to make this query works shorter? Can anybody suggest anything?</P><P>Thanks!</P></BODY></HTML> Wed, 27 Jan 2010 10:32:17 GMT https://community.qlik.com/t5/QlikView/query-works-too-long/m-p/223740#M76222 2010-01-27T10:32:17Z AW:query works too long https://community.qlik.com/t5/QlikView/query-works-too-long/m-p/223741#M76223 <HTML><HEAD></HEAD><BODY><P>Thats a database problem. You need an db-index on customerdocumentid and customernumber, then it should work.</P><P></P><P>Greetings Alex:)</P></BODY></HTML> Wed, 27 Jan 2010 11:41:19 GMT https://community.qlik.com/t5/QlikView/query-works-too-long/m-p/223741#M76223 2010-01-27T11:41:19Z