PERFORMANCE TUNING SYSTEM FOR DATABASE MANAGEMENT SYSTEM

摘要

PROBLEM TO BE SOLVED: To select an SQL group including a search system SQL and an update system SQL for finding an effective tuning method in an SQL group unit.;SOLUTION: An SQL group to be tuned is selected from statistic information accumulated through actual work operation and from an execution frequency and SQL processing time. Weighting matching priority is carried out among the SQL group, and a score target value is decided for each SQL. Tuning is carried out on the target SQL to calculate a score, and tuning satisfying the target value is decided.;COPYRIGHT: (C)2007,JPO&INPIT