Re: If i uses exist then is it optimized or un opt... - Qlik Community

vinod22kv · ‎2017-09-29

Hi,

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

Regards,

vinod

its_anandrjs · ‎2017-09-29

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

Ex:-

Load

*

From source Where Exists(Fieldname)

swuehl · ‎2017-09-29

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

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

swuehl · ‎2017-09-29

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