SQL and Oracle Tuning

This was a question asked during an interview

Table emp has three columns :

empno
ename
dept_code

Now if u write :

SELECT * FROM EMP;
and
SELECT empno,ename,dept_code FROM EMP;

Which statement is more optimal and why?

I have already tried an 'explain plan' on them - it yields similar results. That is, a full table access is carried out for both statements.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Aug 30 1998 - 10:01:22 CDT