International Business Machines Corporation

Kou-Horng A Yang

Hong Min

Terence Patrick Purcell

You-Chin Gene Fuh

Jeffrey Allen Berger

Yue Huang

A method, system, and computer program product are provided for retrieving records into a main memory. A first number of gaps and a first total gap size are received for a list of records from a database subsystem. A determination is made of a first average gap size using the first number of gaps and the first total gap size. A determination is made as to whether the first average gap size is greater than a prestaging threshold value. Responsive to the first average gap size being equal to or less than the prestaging threshold value, a prestaging flag is set for the list of records. Then, the list of records is retrieved into the main memory using prestaging.

Growing community of inventors

Saratoga, CA, United States of America

Kou-Horng A Yang