( 1 ) designing and assigning the tablespace and bufferpool and adopting appropriately correlative optimization method and technique to optimize the performance of the system practically . ( 2 ) optimizing the data dictionary , parts of sources code sql sentence and parametric query optimization . ( 3 ) adjusting and improving record parameter , performance parameter and application parameter which affect the performance of the system primary 最后,結(jié)合某人力資源管理信息系統(tǒng),采用相關(guān)的優(yōu)化技術(shù)和技巧,進(jìn)行一些實(shí)例優(yōu)化: ( 1 )重新設(shè)計(jì)、分配表空間和緩沖池,適當(dāng)采用反規(guī)范化設(shè)計(jì)優(yōu)化和增建索引; ( 2 )對字典表,部分源代碼sql語句和參數(shù)查詢進(jìn)行優(yōu)化; ( 3 )對主要影響應(yīng)用系統(tǒng)性能的日志參數(shù)、性能參數(shù)和應(yīng)用程序參數(shù)進(jìn)行調(diào)優(yōu)設(shè)置和改進(jìn);通過這一系列的優(yōu)化改進(jìn),使得該應(yīng)用系統(tǒng)性能得到了提高;取得了良好使用效果,具有較高的實(shí)用價(jià)值。