Cost-based optimizations for join queries with union all views and derived tables
US11113283B2 · kind B2 · utility
0Cited by
7References
19Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 18, 2017 |
| Grant date | Sep 7, 2021 |
| Priority date | — |
| Expiry date | Jan 20, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query having a Union All view is identified. A logical join between Union AH view/derived table and other tables is broken down into multiple physical joins. The physical joins are pushed to the branches. Cost-based processing statistics are obtained for the branches. An optimal plan for the joins is selected based on the statistics; representing an optimal query execution for the query. The optimal query execution plan is provided to a database engine for executing the optimal query execution plan against a data warehouse.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.