Karol Bieniaszewski asks:

What does this field mean really? I do not understand description in the parenthesis as in this table are field for e.g. - MON$RECORD_DELETES (number of deleted records)

  • MON$RECORD_BACKOUTS (number of backed out records)
  • MON$RECORD_PURGES (number of purged records)
  • MON$RECORD_EXPUNGES (number of expunged records)

Dimitry Sibiryakov answers:

  • BACKOUTS - Latest version of the record was removed so it is returned to previous one.
  • PURGES - Previous version of the record was removed so it cannot be rolled back there anymore.
  • EXPUNGES - The record is completely erased from database.

Like this post? Share on: TwitterFacebookEmail

Related Articles


Firebird Community



Gems from Firebird Support list