JP2002163289A5 - - Google Patents
Download PDFInfo
- Publication number
- JP2002163289A5 JP2002163289A5 JP2001296546A JP2001296546A JP2002163289A5 JP 2002163289 A5 JP2002163289 A5 JP 2002163289A5 JP 2001296546 A JP2001296546 A JP 2001296546A JP 2001296546 A JP2001296546 A JP 2001296546A JP 2002163289 A5 JP2002163289 A5 JP 2002163289A5
- Authority
- JP
- Japan
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US09/671224 | 2000-09-27 | ||
| US09/671,224 US6757671B1 (en) | 2000-09-27 | 2000-09-27 | Use of indices for queries with comparisons on a function |
Publications (3)
| Publication Number | Publication Date |
|---|---|
| JP2002163289A JP2002163289A (ja) | 2002-06-07 |
| JP2002163289A5 true JP2002163289A5 (enExample) | 2008-11-06 |
| JP4879425B2 JP4879425B2 (ja) | 2012-02-22 |
Family
ID=24693623
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| JP2001296546A Expired - Lifetime JP4879425B2 (ja) | 2000-09-27 | 2001-09-27 | 関数に基づく比較を有するクエリのためのインデックスの使用 |
Country Status (4)
| Country | Link |
|---|---|
| US (1) | US6757671B1 (enExample) |
| EP (1) | EP1193619B1 (enExample) |
| JP (1) | JP4879425B2 (enExample) |
| AT (1) | ATE522871T1 (enExample) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7188334B1 (en) * | 2001-11-20 | 2007-03-06 | Ncr Corp. | Value-ordered primary index and row hash match scan |
| US7213011B1 (en) * | 2002-04-08 | 2007-05-01 | Oracle International Corporation | Efficient processing of multi-column and function-based in-list predicates |
| US7685104B2 (en) * | 2004-01-08 | 2010-03-23 | International Business Machines Corporation | Dynamic bitmap processing, identification and reusability |
| US20050210023A1 (en) * | 2004-03-18 | 2005-09-22 | Renato Barrera | Query optimizer using implied predicates |
| US20060064650A1 (en) * | 2004-09-20 | 2006-03-23 | International Business Machines Corporation | Method, system, and computer program product for type-based table navigation |
| US10664474B1 (en) * | 2013-03-15 | 2020-05-26 | Progress Software Corporation | Query system |
| US10262033B2 (en) * | 2016-03-18 | 2019-04-16 | International Business Machines Corporation | Method for query execution planning |
Family Cites Families (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4774657A (en) * | 1986-06-06 | 1988-09-27 | International Business Machines Corporation | Index key range estimator |
| JPH01219927A (ja) * | 1988-02-29 | 1989-09-01 | Hitachi Ltd | データベースの情報検索方式 |
| JP2780996B2 (ja) * | 1989-03-10 | 1998-07-30 | 富士通株式会社 | 問い合わせ最適化処理方法 |
| JPH04199275A (ja) * | 1990-11-26 | 1992-07-20 | Oki Electric Ind Co Ltd | データベース検索装置 |
| US5918225A (en) * | 1993-04-16 | 1999-06-29 | Sybase, Inc. | SQL-based database system with improved indexing methodology |
| US5664172A (en) * | 1994-07-19 | 1997-09-02 | Oracle Corporation | Range-based query optimizer |
| US5548754A (en) * | 1995-02-07 | 1996-08-20 | International Business Machines Corporation | Optimization of SQL queries using early-out join transformations |
| US5548755A (en) * | 1995-02-17 | 1996-08-20 | International Business Machines Corporation | System for optimizing correlated SQL queries in a relational database using magic decorrelation |
| US5727197A (en) * | 1995-11-01 | 1998-03-10 | Filetek, Inc. | Method and apparatus for segmenting a database |
| US6006219A (en) * | 1997-11-03 | 1999-12-21 | Newframe Corporation Ltd. | Method of and special purpose computer for utilizing an index of a relational data base table |
| US6081799A (en) * | 1999-05-05 | 2000-06-27 | International Business Machines Corporation | Executing complex SQL queries using index screening for conjunct or disjunct index operations |
-
2000
- 2000-09-27 US US09/671,224 patent/US6757671B1/en not_active Expired - Lifetime
-
2001
- 2001-09-26 EP EP01123066A patent/EP1193619B1/en not_active Expired - Lifetime
- 2001-09-26 AT AT01123066T patent/ATE522871T1/de not_active IP Right Cessation
- 2001-09-27 JP JP2001296546A patent/JP4879425B2/ja not_active Expired - Lifetime