if do load distinct in script will it effect to qvw performance ?
from .... qvd;
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.,
View solution in original post
If your table has duplicate records then only it helps. or else it takes time same as previous one.