Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inner Keep, vs Exists - which is quicker

Hi

I have a fairly large fact table of 125m records.

In your opinion would it be quicker to use Inner Keep to reduce the fact table or the Exists() function?

Thanks!

3 Replies
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

Exists function reloading time filtering data

inner keep function reload finished after filter data in memory.

so better use exists function useful for u

Not applicable
Author

thanks.

Would appreciate other peoples views as well....

hic
Former Employee
Former Employee

I would say that inner keep is much faster than "Where Exists()". The exists() function makes a lookup for each record (which takes time for large tables) whereas inner keep compares two binary vectors after the load.

The exists() however has the advantage that it is easier to understand when you read the script a year later and have forgotten what you did...

I suggest you try both and see for yourself.

HIC