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 ? Thanks ! Tan ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly