Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod22kv
Creator
Creator

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

Hi,

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

Regards,

vinod

4 Replies
its_anandrjs

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

Ex:-

Load

*

From source Where Exists(Fieldname)

swuehl
MVP
MVP

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

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

vinod22kv
Creator
Creator
Author

Thanks it's helpful.