A tuning apparatus which analyzes and improves performance of a relational database, wherein the apparatus comprises: acquiring means for acquiring predetermined execution information provided when all commands issued via a predetermined query language to the relational database are executed by a database management system; extracting means for extracting as a pair of acquisition patterns both search condition information and search method information for acquiring searched results of data by executing the respective commands; and generating means for generating a tuning table in which the respective executed acquisition patterns are grouped as acquisition pattern groups which are grouped for each of objects of the relational database and each of the acquisition patterns and the acquired execution information corresponding to each of the acquisition patterns are composed as a sequence of tuning information, wherein the search condition information is specified by both column data for narrowing down a target to be searched and operator data given by describing search condition in relation to the column data in a form of the query language, wherein the search method information is specified by both index data which are set to the column data for narrowing down the target and scan formula data showing a search path which is set to the object, wherein the generating means comprises an electing means which identify, from the acquisition patterns of the respective objects, an acquisition pattern being tuned based on the execution information; and a selecting means which read, from the elected acquisition pattern, column data which has not been selected as the index data and select the index data from the read column data according to a predetermined condition, and wherein the generating means incorporate the selected index data into the tuning table. acquiring means for acquiring predetermined execution information provided when all commands issued via a predetermined query language to the relational database are executed by a database management system; extracting means for extracting as a pair of acquisition patterns both search condition information and search method information for acquiring searched results of data by executing the respective commands; and generating means for generating a tuning table in which the respective executed acquisition patterns are grouped as acquisition pattern groups which are grouped for each of objects of the relational database and each of the acquisition patterns and the acquired execution information corresponding to each of the acquisition patterns are composed as a sequence of tuning information, wherein the search condition information is specified by both column data for narrowing down a target to be searched and operator data given by describing search condition in relation to the column data in a form of the query language, wherein the search method information is specified by both index data which are set to the column data for narrowing down the target and scan formula data showing a search path which is set to the object, wherein the generating means comprises an electing means which identify, from the acquisition patterns of the respective objects, an acquisition pattern being tuned based on the execution information; and a selecting means which read, from the elected acquisition pattern, column data which has not been selected as the index data and select the index data from the read column data according to a predetermined condition, and wherein the generating means incorporate the selected index data into the tuning table. <EOS>