"Tan Chen Yee" <tancy@xxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
