摘要 |
PROBLEM TO BE SOLVED: To provide an index management technique capable of maintaining retrieval efficiency and data storage efficiency in table data including a plurality of fields in spite of frequent update of the fields. SOLUTION: When table data including a plurality of fields (columns) is managed on a computer, an index for the table data, a management object is created for columns with low update frequency except columns with high update frequency. At the time of search, it is checked whether a search condition for the columns with low update frequency is included in a designated search condition or not, and when it is included, search using the index is performed. Records are narrowed at high speed by the search using the index, and search is performed by sequential search to the narrowed records with a search condition for the columns with high update frequency excluded from the index structure. COPYRIGHT: (C)2008,JPO&INPIT
|