Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Hareeshkommineni
Contributor III
Contributor III

Optimization techiniques

I have data from 4 countrys i want take only one country data without doing any transformations

if we are using where function it can be the unoptimization that why i want to take only one country data with using transformations

it is possible or not?

 

advance thanks

harish

3 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

You're correct in that normally using a where clause will break QVD optimisation. There is one exception to this though, which you could take advantage of here. This is when you use the EXISTS function.

In your case, you could load a simple inline table containing just the Name / ID of the country you want to load, then use EXISTS on your existing load.

 

For example:

tmpCountry:

LOAD * INLINE [

Country

UK

];

 

Data:

LOAD *

FROM [your qvd]

WHERE EXISTS (Country)

;

Hareeshkommineni
Contributor III
Contributor III
Author

if we are use where exists () it is optimized or unoptimized?
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Optimised