首页>
外国专利>
Query optimization technique for obtaining improved cardinality estimates using statistics on pre-defined queries
Query optimization technique for obtaining improved cardinality estimates using statistics on pre-defined queries
展开▼
机译:查询优化技术,用于使用预定义查询的统计信息来获得改进的基数估计
展开▼
页面导航
摘要
著录项
相似文献
摘要
A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Statistics on one or more pre-defined queries are used to determine an optimal query execution plan for the query. In particular, improved cardinality estimates are generated for one or more query execution plans for the query using statistics of one or more pre-defined queries that vertically overlap the query. These cardinality estimates are used to make more accurate cost estimates, thus improving the likelihood of determining the optimal query execution plan.
展开▼