Database Concepts › Physical Structures › Location Mode › DIRECT Location Mode

DIRECT Location Mode

DIRECT location mode allows the user to suggest the page on which to store a record. It is used less frequently tha CALC or VIA because it places the burden of locating records on the application program.

One use of DIRECT mode is to store records serially in an area, which is accomplished by targeting each new record to the page of the most recently stored record. (The database key of the record just stored is returned to the program). The DBMS either stores the record on the suggested target page or on the next page with sufficient space.