Oracle and SQL Tuning

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.

-----== 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:21 CDT