QlikView solving slow QVD Load (not qvd optimized) with Where condition. A Load DISTINCT from QVD can be optimized too and is really fast (example would work without distinct although). So, this two-step approach is 2x faster.. The idea is to push the Where condition into a exists scenario.

QlikView_solving_slow_QVD_Load.qvw

/* Slow Load, not qvd optimized:
Bookings:
LOAD * From Bookings.qvd (qvd)
Where ID>0; // ..or with other condition: Not IsNull(ID)
*/

// qvd optimized
ExistingID:
LOAD DISTINCT ID From Bookings.qvd (qvd);

// qvd optimized
Bookings:
LOAD * From Bookings.qvd (qvd)
Where Exists(ID);

Drop Table ExistingID;