Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Yes first one will be more optimized.
regards
ASHFAQ
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