The general consensus is that it's unnecessarilly inefficient. Not
everyone agrees obviously.
...
I should probably clarify this some...
Some people will tell you that even if you're going to draw every
column in the query anyway, you should still list each individual
column in the query because the database server has to take some small
amount of time to assemble the list when you specify the wildcard ...
not everyone agrees with this. Others say you should specify
individual columns unless you intend to use all the columns in the
query because it takes less time to get the part of the data you need
than to get all the data. Especially if you happen to have text or
clob columns, I can't really find fault with this myself, but in cases
where every column in the query is used, I see nothing wrong with
using the wildcard.
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
