Efficient query to fetch the columns in an entire relation?

From: KSS Vijaya Bhaskar <kssvbhaskar_at_indiatimes.com>
Date: 17 Jul 2002 00:12:43 -0700
Message-ID: <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

SELECT * FROM relation_name;

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 Wed Jul 17 2002 - 09:12:43 CEST

This message: [ Message body ]
Next message: Paul: "How to model disjoint date ranges?"
Previous message: Steve Kass: "Re: one big table or many smaller tables"
Next in thread: Tobin Harris: "Re: Efficient query to fetch the columns in an entire relation?"
Reply: Tobin Harris: "Re: Efficient query to fetch the columns in an entire relation?"
Reply: Alan: "Re: Efficient query to fetch the columns in an entire relation?"
Reply: Ruud de Koter: "Re: Efficient query to fetch the columns in an entire relation?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message