Invention Grant
- Patent Title: Optimizing search trees by increasing success size parameter
- Patent Title (中): 使用列表查询优化对数据库的访问
-
Application No.: US11535632Application Date: 2006-09-27
-
Publication No.: US07882101B2Publication Date: 2011-02-01
- Inventor: Grace Au , Bhashyam Ramesh , Haiyan Chen
- Applicant: Grace Au , Bhashyam Ramesh , Haiyan Chen
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agent John Cowart, Senior Attorney
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30
Abstract:
A SQL query that includes an IN-List is optimized by (1) performing an evaluation to determine whether access to a table can be performed as a join operation, (2) converting the IN-List to an IN-LIST relation, and (3) joining the IN-List relation with the table to access the data in the table.
Public/Granted literature
- US20070073647A1 OPTIMIZING ACCESS TO A DATABASE Public/Granted day:2007-03-29
Information query
