In addition:

- If you are only selecting a couple of fields and they all happen to be in the index you are using, the DBMS can get away with only reading the index and not the physical record, resulting in one less disk access.

- By limiting the columns you ask for to the ones you need, you can save a little bit on network traffic.


On Thu, 12 October 2000, "Ashish" wrote:
>    I remember some time back there was some mention about not using 'select
> *' in a statement but using the exact columns. Went through the archives,
> article ? I need to enforce this and have to do some hard convincing, and
> some solid reason which I can quote.

Get Your Free, Private FarmDance at http://farmer.oracular.com/
_______________________________________________________________________

Free Unlimited Internet Access! Try it now! 
http://www.zdnet.com/downloads/altavista/index.html

_______________________________________________________________________