In-row LOB Columns

Use inrow_lob_length to increase or decrease the in-row LOB length database-wide.

The SAP ASE server uses in-row LOB compression if:
  • The table is implicitly or explicitly row- or page-compressed, and,

  • Any of the in-row large object columns in the table are implicitly or explicitly LOB compressed.

Changing the inrow_lob_length affects the creation of LOB columns in future create table or alter table add column commands. The valid values are within the range of 0 to the logical page size of the database.