Don't Use Select * in Database Queries

June 3, 2005

[From ASP101]

Something you see in a lot of database access code is a select statement that looks something like this:

SELECT * FROM TableName WHERE ... 

While there's technically nothing wrong with it, using the SELECT * syntax could be stealing away precious performance from your application, and even it it's not now, it might someday soon.

The article continues at

The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers