Inventor
TIE HONG SANG
US13 patents
Patents
13 patentsUS6272487B1Aug 7, 2001
Query optimization through the use of multi-column statistics to avoid the problems of non-indexed column correlation
IBM125 citations99
US6006220ADec 21, 1999
Determining the optimal access path for a query at execution time using an actual value for each variable in a query for estimating a filter factor
IBM119 citations97
US5940819AAug 17, 1999
User specification of query access paths in a relational database management system
IBM98 citations97
US6397204B1May 28, 2002
Method, system, and program for determining the join ordering of tables in a join query
IBM114 citations96
US6219660B1Apr 17, 2001
Access path selection for SQL with variables in a RDBMS
IBM103 citations96
US5995957ANov 30, 1999
Query optimization through the use of multi-column statistics to avoid the problems of column correlation
IBM74 citations96
US5692174ANov 25, 1997
Query parallelism in a shared data DBMS system
IBM165 citations96
US5978792ANov 2, 1999
Method and apparatus for generating dynamic and hybrid sparse indices for workfiles used in SQL queries
IBM69 citations95
US5758145AMay 26, 1998
Method and apparatus for generating dynamic and hybrid sparse indices for workfiles used in SQL queries
IBM74 citations95
US7146365B2Dec 5, 2006
Method, system, and program for optimizing database query execution
IBM65 citations94
US6081799AJun 27, 2000
Executing complex SQL queries using index screening for conjunct or disjunct index operations
IBM49 citations92
US6513028B1Jan 28, 2003
Method, system, and program for searching a list of entries when search criteria is provided for less than all of the fields in an entry
IBM40 citations91
US6496823B2Dec 17, 2002
Apportioning a work unit to execute in parallel in a heterogeneous environment
IBM36 citations87