Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor II

Re: Inner Keep, vs Exists - which is quicker

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

Re: Inner Keep, vs Exists - which is quicker

thanks.

Would appreciate other peoples views as well....

Employee
Employee

Re: Inner Keep, vs Exists - which is quicker

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

Community Browser