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 - 12:36:26 CDT
