Hi all ,

I am connecting to DB2 using Dynamic SQL called from Java.
I am building SQL Query string on the fly and submitting query to DB2.

My question here is this ,

Column sequence in SQL 'Insert' or 'Select' clasue will improve any performance of SQL ?

e.g.
Tabel structure defined as

table name - emp

empname char(100)
empno char(10)

Select empname , empno from emp;

is it better than

Select empno , empname from emp; ?

also in insert clause

insert into table emp(empname , empno) values('XYZ','12') ;
is it better than
insert into table emp(empno,empname) values('12','XYZ') ;

Do Reply

-A