Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Join performance: single on string or double on integers?

I am afraid this was discussed before, but unfortunately what is being discussed here and here is beyond my level of understanding.

My issue: I need to join two tables during script execution, the row count is in the millions, so any performance improvement is welcome. I currently join on a string field that is the concatenation of two integer fields, '00_12345' = '00_12345'. 

Since the tables also have the original fields I was wondering whether a double join on 00 = 00 and 12345 = 12345 would reduce script runtime.

Thank you,

Igor

 

Labels (3)
1 Reply
Highlighted
Partner
Partner

Re: Join performance: single on string or double on integers?

Hi,

I just testing your question and I can check that the join on double integers is better than string.

I attach a .qvw file. In script editor you can test this.

I hope it is useful for you.

Dan.