Fragment smart large objects
You can specify multiple sbspaces in the PUT clause of
the CREATE TABLE statement to achieve round-robin fragmentation of
smart large objects on a column. If you specify multiple sbspaces
for a CLOB or BLOB column, the database server distributes the smart
large objects for the column to the specified sbspaces in round-robin
fashion. Given the following CREATE TABLE statement, the database
server can distribute large objects from the cat_photo column
to sbcat1, sbcat2, and sbcat3 in round-robin
fashion.
CREATE TABLE catalog (
catalog_num SERIAL,
stock_num SMALLINT,
manu_code CHAR(3),
cat_descr LVARCHAR,
cat_photo BLOB)
PUT cat_photo in (sbcat1, sbcat2, sbcat3;