Sybase 12.5.1, User Manual, Page: 132 / 210

Table of data items and definitions
118
Historical Server
Rows Deleted
Version: 11.0 and later
Number of rows deleted from a database table.
Type: Result
Rows Deleted Deferred
Version: 11.0 and later
Number of rows deleted from a database table in deferred mode.
Type: Result
Rows Deleted Direct
Version: 11.0 and later
Number of rows deleted from a database table in direct mode.
Type: Result
Rows Inserted
Version: 11.0 and later
Insertions into a database table.
Type: Result
Rows Inserted Clustered
Version: 11.0 and later
Insertions into database tables with clustered indexes.
Type: Result
Rows Inserted Heap
Version: 11.0 and later
Insertions into database tables without clustered indexes.
Type: Result
Rows Updated
Version: 11.0 and later
Updates to a database table.
Type: Result
Rows Updated Deferred
Version: 11.0 and later
Updates that require two steps to complete. First, records for deleting the existing entry
and inserting the new entry are written to the log, but only the deletes are actually
performed on the data pages. In the second step, the log is rescanned and the insert
operations performed on the data pages.
Type: Result
Rows Updated Direct
Version: 11.0 and later
The sum of expensive, in-place, and not-in-place updates (everything except updates
deferred).
Type: Result
Rows Updated Expensive
Version: 11.0 and later
A type of direct update that deletes a row from its original location and inserts it in a
new location.
Rows Updated In Place
Version: 11.0 and later
A type of direct update that does not require rows to move on a data page.
Type: Result
Rows Updated Not In
Place
Version: 11.0 and later
A type of direct update that does not require the updated row to move, but because the
length of the updated row changes, other rows on the data page are moved. Also known
as cheap updates.
Type: Result
Data item Description