Discussion board where members can get started with QlikView.
if do load distinct in script will it effect to qvw performance ?
from .... qvd;
Go to Solution.
Yes, Definitely, it'll improve performance.
Join and concatenate, outputs most of the records from data source.
It'll remove Duplicate records from input as well as Output. Records count is less.
So, when using Distinct, should have a temp table.,
If your table has duplicate records then only it helps. or else it takes time same as previous one.