| 摘要 |
PROBLEM TO BE SOLVED: To provide a generation method for index and a computer system that suppress an increase in reference cost in referring to a database.SOLUTION: A computer system comprises an SQL processing part 111, a parameter management part 112, a buffer memory 115, a buffer memory management part 114, a parameter generation part 113, and an index generation part 116, and the parameter generation part includes means of acquiring basic information on an index to be generated, table information, and buffer memory capacity from the parameter management part and comparing the buffer memory capacity with capacity of the index so as to calculate a fill factor for each layer of indexes, means of comparing capacity of an index to be newly generated with the capacity of a storage area of a buffer memory, and means of generating a new index having the fill factor re-set for each layer by increasing a fill factor of a leaf node of the index when the buffer memory capacity is not large enough. |
