Dear All,
Could you please let me know which one have better performance.
Say emp table has 3 million records and 150 columns. which sql statement will perform better. I am not asking which is better practice but i am taking about the performance.
select * from emp;
and
select ename,deptno,location from emp;
Regards
Rajat