Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and SQL Tuning
wrote:
> This was a question asked to me during an interview :
>
> What is the difference between
>
> SELECT * from emp;
>
> and
>
> SELECT empno,ename,dept_code from emp;
>
> emp is a table with only three columns --> empno,ename and dept_code
>
> Which statement is more optimal ?
>
> i tried an explain plan on both statements and got similar results i.e.
> full table access on table emp for both statements.
>
>>
Might be stupid but
I would say the first one because you have less code to type !!!!
Apart from that, I have no idea neither.
Regards,
Lalaina
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 01 1998 - 06:09:49 CDT