Query Optimization Strategy of DB2 Database
Zhuo Wang · Modern Electronics Technique · 2006
Query optimization of database is an important measure to improve the application performance.Through analyzing the optimization principle of IBM DB2 query optimizer,some useful advises on updating statistical information,building indexes and constructing SQL to improve query performance are given,which are proved strictly by SQL sentences in the testing scheme.The developers must analyze the time and memory cost to write good SQL sentences.