Direct Query

[#1]

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

[rustyfishbones]

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