DZone voters are special people. Be special. Login and vote now.
By bloid
via weblogs.asp.net
Published: Jul 19 2007 / 17:38
Let's take a look at a sample. The following two queries select 326 rows from the TransactionHistoryArchive table in the AdventureWorks database (which has a total of 89K rows). The first uses a SELECT * query, the second selects a specific column:
Comments
daniel replied ago:
It's also worth noting that if you do something like:
SELECT * FROM tableA JOIN tableB ON tableA.fieldA = tableB.fieldB
That's a pretty sizable performance hit.
Voters For This Link (19)
Voters Against This Link (0)