homepage Welcome to WebmasterWorld Guest from Become a Pro
Member Visit PubCon.com Forum Library, Charter, Moderator: open
Databases Forum  SQL Tuning Tips Fast, Faster, Fastest ...
 4:30 am on Sep 29, 2005 (gmt 0)  SQL is the heart of a
Relational DB system. The first consideration when writing an
SQL statement is that it return a correct result. The second is
that it be the most efficient for a given situation.  Following
are some general tips that often increase SQL statement
efficiency. Being general they may not apply to a particular
scenario. Any code comparisons are greatly simplified concept
examples - not efficiency test cases.  Remember that processing
SQL is a sequence of Parse (syntax check and object resolution),
Execution (required reads and writes), and Fetch (row results
retrieved, listed, sorted, and returned). SQL "tuning" consists,
quite simply, of reducing one or more of them.  Note: generally
Parse is the greatest time and resource hog. Parse overhead can
be minimised by the use of Proc