International Business Machines Corporation

Terry Dennis Allen

Akira Shibamiya

Annie S Tsang

Fen-Ling Lin

Hong Sang Tie

Paramesh Sampatrai Desai

Hsiuying Yen Cheng

Aspects for improving response time for database query execution are described. The aspects include comparing an estimate of sort pages needed for a database query against at least one threshold. A determination of whether to perform a parallel sort for the database query based on the comparison occurs, wherein response time improvement by the parallel sort is balanced against resource overhead of the parallel sort.

Method and system for improving response time for database query execution

Disclosed is a method, system, and program for database query execution. A range of data pages is assigned to each of multiple parallel tasks. For each of the multiple parallel tasks, the range of data pages is mapped to one or more physical partitions, and a data partitioned secondary index partition associated with each of the one or more physical partitions is identified. Each of the multiple parallel tasks is executed to process the database query against the assigned range of data pages using the one or more data partitioned secondary index partitions.

Method, system, and program for optimizing database query execution

Growing community of inventors

San Jose, CA, United States of America

Terry Dennis Allen