Question regarding load and select statements?

[chiru_thota]

Hi All,

I have 100 columns in table but I need only 3 columns out of them.

Will they be any difference in terms of performance between below two statements  ( Select )

(1)  Load Column1,Column2,Column3 ; 

      select Column1,Column2,Column3 from tablename;

(2)  Load Column1,Column2,Column3 ; 

      select * from tablename;

Thanks,

Chiru

[ashfaq_haseeb]

Hi,

Yes first one will be more optimized.

regards

ASHFAQ

[maxgro]

the difference is the size of data you transfer from the database server to qlik server (or publisher server)

--> time to transfer, time to load

.

if you extract N rows from the database

(1) N rows * 3 columns

(2) N rows * 100 columns