Direct Query

Wed, 22 Jan 2014 16:25:43 GMT

Hi all,

Quick question : with using Direct query, is there another way to create a different condition

In tech doc, it explains that when you select 10 id of customer ID, Qlikview creates this SQL :

SELECT DISTINCT "SalesPersonID" FROM "AdventureWorks"."Sales"."SalesOrderHeader" WHERE

"CustomerID" IN ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 )

But, if you have 10 000 customerID selected you have this SQL

SELECT DISTINCT "SalesPersonID" FROM "AdventureWorks"."Sales"."SalesOrderHeader" WHERE

"CustomerID" IN ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 .. 10000)

So it's not performant for a SQL Server, it will be more performant with this SQL

SELECT DISTINCT "SalesPersonID" FROM "AdventureWorks"."Sales"."SalesOrderHeader" WHERE

"CustomerID" > 1

and "CustomerID" < 10001

Any ideas ?

thanks

Re: Direct Query

rustyfishbones — Wed, 22 Jan 2014 17:28:42 GMT

Add FIRST before the LOAD statement, maybe like below, it will only load the first 10 rows from the Database

You could say FIRST 10000 and then ORDER BY CustomerID