"Tan Chen Yee" <tancy@gussmanntech.com> writes:
> If I want to retrieve all columns from a table, is there any disadvantage by
> using select *
> instead of listing all the columns ? Will select * cause overhead, more
> times to run ?
No, it shouldn't make any difference there. The disadvantage of
SELECT * is that adding, removing or changing columns can break your
client code (depending on what client library you're using) because
the records returned by a query will change format without warning.
-Doug