Invention Grant
- Patent Title: Query plan searching and optimization
-
Application No.: US15852597Application Date: 2017-12-22
-
Publication No.: US10891290B2Publication Date: 2021-01-12
- Inventor: John Mark Morris , Bhashyam Ramesh , Donald Raymond Pederson , Kuorong Chiang
- Applicant: Teradata US, Inc.
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agency: Schwegman, Lundberg & Woessner, P.A.
- Agent Howard Speight
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453

Abstract:
Search spaces for obtaining query execution plans for a query are identified. The search spaces are subdivided into sub-search spaces. Searches are initiated within the sub search spaces and plan costs for competing query execution plans are noted along with search costs associated with continuing to search the sub-search spaces. A decision is made based on the plan costs and search costs for utilizing search resources as to when to terminate the searching and to select the then-existing lowest cost query execution plan as an optimal query execution plan for executing the query.
Public/Granted literature
- US20190197163A1 QUERY PLAN SEARCHING AND OPTIMIZATION Public/Granted day:2019-06-27
Information query