Re: Oracle and SQL Tuning

From: <ndreon_at_my-dejanews.com>
Date: Mon, 31 Aug 1998 17:39:53 GMT
Message-ID: <6sen59$psb$1@nnrp1.dejanews.com>

I am just speculating but perhaps the 'Select * from emp' would run with fewer resources because it allows Oracle more freedom. It seems like choosing a particular order for the columns could require some resources to change the output from some default stored order into the requested one.

If you find out more I would be interested to hear about it.

Nathan

In article <6sbpg1$fuc$1_at_nnrp1.dejanews.com>, jayu_c_at_my-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.
>
> -----== 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 Mon Aug 31 1998 - 12:39:53 CDT