Hewlett-Packard Development Company, L.p.

Teradata US, Inc.

Vijay Sarathy

Harumi Kuno

Paul Laurence Sinclair

Grace Kwan-On Au

Rama Krishna Korlapati

Murali Mallela Krishna

Subrata Naskar

Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan based on metrics. When the dynamic query execution plan is used, a request fragment of the request is planned and the corresponding plan fragment is executed. The processed fragment provides feedback related to its processing to the remaining request and the process is repeated on the remaining request until the request is completed.

Techniques for improving the performance of complex queries

A method of performing a database join includes receiving a query. The query may specify a join of a first table and a second table. The method further includes determining a new predicate based on a mapping between a first column of the first table and a second column of the second table for a plurality of tuples of the join. Further, the method includes modifying the query such that the query comprises the new predicate.

Performing database joins

Growing community of inventors

Portland, OR, United States of America

Vijay Sarathy