Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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....

Highlighted
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