SQL Performance Basics: Part 2, Rely on Indexes

(Craig S. Mullins) Perhaps the single most important aspect of SQL tuning is indexing. All developers should know all of the indexes that exist on any table upon which they write SQL statements. When an index exists on a column (or columns), DB2 can use the index to reduce I/O instead of scanning th

Read More - Register for Free Membership