首页>
外国专利>
OPTIMIZING A QUERY TO A PARTITIONED DATABASE TABLE USING A VIRTUAL MAINTAINED TEMPORARY INDEX THAT SPANS MULTIPLE DATABASE PARTITIONS
OPTIMIZING A QUERY TO A PARTITIONED DATABASE TABLE USING A VIRTUAL MAINTAINED TEMPORARY INDEX THAT SPANS MULTIPLE DATABASE PARTITIONS
展开▼
机译:使用虚拟维护的临时索引(跨多个数据库分区)优化对分区数据库表的查询
展开▼
页面导航
摘要
著录项
相似文献
摘要
A query optimizer optimizes a query to a partitioned database table by determining common characteristics of the partitions and generating a virtual maintained temporary index that spans multiple partitions. Using the virtual maintained temporary index allows the query optimizer to generate an access plan based on the virtual maintained temporary index, which relieves the optimizer from having to individually optimize access to each partition for partitions that share common characteristics.
展开▼