If i uses exist then is it optimized or un optimized Load?

[vinod22kv]

Hi,

Please let me know if i used EXIST in qvd load then is it optimized or un optimized  Load?

Regards,

vinod

[its_anandrjs]

If you use Where Exists at the end of the table load

Ex:-

Load

*

From source Where Exists(Fieldname)

[swuehl]

Exists(FIELDNAME) in the WHERE clause will keep the LOAD optimized.

Exists(FIELDNAME, Expression) in the WHERE clause will make the LOAD unoptimized.

[swuehl]

See also

https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

[vinod22kv]

Thanks it's helpful.