Re: Efficient query to fetch the columns in an entire relation?
Date: Thu, 18 Jul 2002 13:36:26 -0400
Message-ID: <ah6uag$qcbiv$1_at_ID-114862.news.dfncis.de>
Performance is not the reason to choose one over the other. The difference is negligible. There are other reasons to consider, depending on the situation.
"KSS Vijaya Bhaskar" <kssvbhaskar_at_indiatimes.com> wrote in message
news:bde31ae9.0207162312.1ac1095f_at_posting.google.com...
> Hello,
>
> Yesterday, I came across one simple question yet interesting.
>
> What is the best way of retrieving all columns in a given relation
> using a SQL query.
>
> Two possible alternatives are
>
> 1. SELECT * FROM relation_name;
>
> 2. SELECT COLUMN1, COLUMN2, ..., COLUMNn FROM relation_name;
>
> I am not able to decide, which is better than the other and more
> importantly
> WHY?
>
> Hope to get some reply on this,
>
> - Vijay
Received on Thu Jul 18 2002 - 19:36:26 CEST