Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and SQL Tuning

Re: Oracle and SQL Tuning

From: <lalaina_at_my-dejanews.com>
Date: Tue, 01 Sep 1998 11:09:49 GMT
Message-ID: <6sgklt$4tp$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US