首页>
外国专利>
Database query optimization using index carryover to subset an index
Database query optimization using index carryover to subset an index
展开▼
机译:使用索引结转来对索引进行子集化的数据库查询优化
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method, apparatus and program product use a first index associated with a field in a database table to identify a range of records in the database table that includes instances of a first key value in the field and use the identified range of records to subset a second index associated with another field in a database table. The database query identifies the first key value for the field in the database table and the second key value for the other field in the database table. By doing so, information from an index may be carried over and applied to another index to subset the other index, often reducing the quantity of entries that are searched in the other index and improving performance.
展开▼