首页>
外国专利>
Optimization of SQL queries using filtering predicates
Optimization of SQL queries using filtering predicates
展开▼
机译:使用过滤谓词优化SQL查询
展开▼
页面导航
摘要
著录项
相似文献
摘要
A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Query predicates involving different data types are identified. A second query predicate is generated which includes matching data types, and if necessary, converted operators. The second query predicate with the matching data types and/or converted operators is executed to obtain a subset of records using an index manager or data manager. The subset of records is converted to the data types of the remaining query predicates. The first query predicate is applied against the subset of records to obtain a result, and the remaining query predicates of the original query are applied to the result of the first query predicate and any other additional converted query predicates to obtain a final result.
展开▼