Saw a posting today that reminded me to review SQL writing and performance. Very useful article...Two ways to improve performance 1) Use Table Indexes2) Identify column names in queries

///////////////////////////////////
TIP:
///////////////////////////////////

Never use "Select *" in queries anywhere! Decreases application/database performance!

///////////////////////////////////
TABLE INDEX:
///////////////////////////////////

"When the programmer queries information, the “where” clause shouldcontain a table field that is a part of the table index. A table indexis normally created by the database administrator, and it decreases theamount of time it takes for a database server to find records. It’sadvantageous for a database administrator to insert table indexes onfields that are commonly queries."http://database-programming.suite101.com/article.cfm/how-to-optimize-sql-select-statements

Signing Off,
Vivian
ViSO Tech