Hi,
I've a qvd sized 56.8 mb, when i left joined it with another qvd having a filter in the where clause and a distinct keyword in the Load statement(loading only 2 fields),
then the resulting qvd is only 26 Mb.
How is it possible that after doing a join of two qvds the size of the resulting qvd is lesser than the size of the larger qvd involved in the join ?