> A very particular situation though. It will not prevent me > from using SELECT * when I need all fields. This is more > efficient than list all of them.
It may be more efficient for you as you type them out, but it will be less efficient for your database, which has to figure out what "*" represents by querying its own information schema. It also won't be more efficient for someone following along behind you, because they won't be able to infer the schema from the query. In the first case, the performance difference will admittedly be minor. In the second case, perhaps no one but you will ever edit the code that you write. Nevertheless, it's safe to say that avoiding "*" is a good idea, and for most people it's easier to adhere to a set of best practices rather than evaluating everything they do, every time they do it, to determine what to do right now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
