A procedure optimizes command execution in a database system. According to one
embodiment, the database system stores data records on data pages, and provides
an identifier for each data page. The identifier indicates when any of the data
records contained in the data page were last modified. A data record is selected
from a data page and copied to a second storage area. Verification that the selected
data record has not been modified since the time that is was copied to the second
storage area is based upon the identifier, and then the command is executed.