公开(公告)号：US20150088857A1

公开(公告)日：2015-03-26

申请号：US14557213

申请日：2014-12-01

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Allison LEE ,  Mohamed ZAIT ,  Yali ZHU

IPC: G06F17/30

CPC classification number: G06F16/24545

Abstract: An improved method, system, and computer program product is disclosed that provides a hybrid approach to optimization which allows different subsets of data accessed by a query to be optimized with different access paths and execution approaches. Transformations may be performed to re-write the query, which restructures the query in a way that facilitates the hybrid optimization process. Multiple transformations may be interleaved to produce an efficient re-written query.

Abstract translation: 公开了一种改进的方法，系统和计算机程序产品，其提供了优化的混合方法，其允许通过不同的访问路径和执行方法来优化由查询访问的不同的数据子集。 可以执行转换以重新编写查询，其以促进混合优化过程的方式重新构建查询。 可以交织多个变换以产生有效的重写查询。