Title:
SQLクエリプランを最適化するための次元コンテキスト伝搬技術
Document Type and Number:
Japanese Patent JP7273045
Kind Code:
B2
Abstract:
Techniques for efficient execution of queries. A query plan generated for the query is optimized and rewritten as an enhanced query plan, which when executed, uses fewer CPU cycles and thus executes faster than the original query plan. The query for which the enhanced query plan is generated thus executes faster without compromising the results obtained or the data being queried. Optimization includes identifying a set of one or more fact scan operations in the original query plan and then, in the rewritten enhanced query plan, associating one or more dimension context predicate conditions with one or more of the set of fact scan operations. This reduces the overall cost of scanning and/or processing fact records in the enhanced query plan compared to the original query plan and makes the enhanced query plan execute faster than the original query plan.
Inventors:
Butani, Harish
Application Number:
JP2020539091A
Publication Date:
May 12, 2023
Filing Date:
January 16, 2019
Export Citation:
Assignee:
Oracle International Corporation
International Classes:
G06F16/2453
Domestic Patent References:
JP2001243242A | ||||
JP2002007435A |
Foreign References:
WO2017163393A1 | ||||
US20150088919 | ||||
US6014656 | ||||
US20160098446 | ||||
US20130173528 | ||||
US20130275364 | ||||
US20170147644 | ||||
US20100312756 |
Attorney, Agent or Firm:
Patent Attorney Fukami Patent Office