Simple-Large-Object Storage and the Descriptor

Data rows that include TEXT or BYTE data do not include the data in the row itself. Instead, the data row contains a 56-byte descriptor with a forward pointer (rowid) to the location where the first segment of data is stored.

The descriptor can point to one of the following items:
  • A page (if the data is stored in a dbspace)
  • A blobpage (if the data is stored in a blobspace)
  • An optical platter (if you are using the Optical Subsystem)