首页>
外国专利>
Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables
Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables
展开▼
机译:匹配和补偿测试,用于使用自动汇总表优化查询中的相关子查询
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method, apparatus, and article of manufacture for optimizing database queries using an automatic summary table. A query is analyzed using matching and compensation tests between the query at least one correlated subquery within the query and the automatic summary table to determine whether expressions occurring in the query, but not in the automatic summary table, can be derived using the automatic summary table. If so, the query is rewritten so that the automatic summary table is used.
展开▼