公开(公告)号：US20240289330A1

公开(公告)日：2024-08-29

申请号：US18113475

申请日：2023-02-23

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： RAFI AHMED ,  ANDREW WITKOWSKI

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/242 ,  G06F16/2455

CPC classification number: G06F16/24535 ,  G06F11/3409 ,  G06F16/244 ,  G06F16/2456

Abstract: A mechanism is provided for performing a group-by pushdown operation or a distinct pushdown operation on a query. The query comprises an outer query block containing a view with a union-all operator, and the outer query block comprises an outer query statement referencing one or more columns of the union-all view and a group-by statement or a distinct keyword. Performing the group-by pushdown operation or the distinct pushdown operation on the query comprises modifying at least a given branch of the union-all view to include a distinct keyword in a query statement of the given branch or a group-by clause that groups results of the given branch by the one or more columns of the table of the given branch.