topic Re: Optimized in QVW in QlikView

Optimized in QVW

Thu, 07 Aug 2014 03:57:25 GMT

Hello Community,

I'm new to qlikview what is meant by Optimized in qvw? and may i have knowledge on optimized and unoptimized QVD Load Situations?

Request to can anyone help me in this in detail.

Thanks&Regards,

Sattish

israrkhan — Thu, 07 Aug 2014 04:03:17 GMT

Kindly see these post, you will get fully idea

Hope it helps....

if not clear , Please ask...

sujeetsingh — Thu, 07 Aug 2014 04:08:01 GMT

Just go through this doc

Thu, 07 Aug 2014 04:36:51 GMT

Hi Sattish,

see with out transformations if u create a qvd is called Optimized qvd ... and when u load data from optimized qvd called optimized load ...

There is a blog written by Steve Dark on this subject: this explains u very good way

jansen28 — Thu, 07 Aug 2014 04:50:02 GMT

Optimized QVD: When you extract data from data sources and load that directly into QVD without using any filters then that is Optimized QVD.

Resident1:

Load column1, Cloumn2;

sql select * from Table1;

Un-Optimized QVD: Using filters while loading i.e transforming data from its original view.

Resident1:

Load column1, Cloumn2

Where column1 = 'A';

sql select * from Table1;