topic Re: Is there any performance impact in using Shared Key in QlikView

Is there any performance impact in using Shared Key

rajat2392 — Mon, 22 Jun 2015 15:16:50 GMT

Hi everyone,

Is there any impact on the performance if I use Shared Keys in a data model?

In my case, Table1 is having some 6 columns and Table2 is having 8 columns with around 1000 and 200 rows.

But the Link table is having 10 columns, and around 200 million rows.

Is there any impact on the performance?

Any help is appreciated.

Thanks

Rajat

hic — Mon, 22 Jun 2015 15:21:11 GMT

There should be no performance penalty for this.

HIC

rajat2392 — Tue, 23 Jun 2015 04:54:27 GMT

Thanks Henry. Thank you so much for quick response.