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.