给你个例子: CREATE TABLE xxxxx (col1 integer, col2 BLOB, col3 CLOB) STORAGE (INITIAL nn NEXT nn) TABLESPACE (row_data_row_ts) LOB (col2, col3) STORE AS (TABLESPACE lob_data_ts STORAGE (INITIAL nn NEXT nn) CHUNK 4 NOCACHE LOGGING INDEX (TABLESPACE lob_idx_ts STORAGE (INITIAL nn NEXT nn) )
你好!blob字段是如何和表分开存储,能再说的详细一点吗?谢谢!
CREATE TABLE xxxxx
(col1 integer,
col2 BLOB,
col3 CLOB)
STORAGE (INITIAL nn NEXT nn)
TABLESPACE (row_data_row_ts)
LOB (col2, col3) STORE AS
(TABLESPACE lob_data_ts
STORAGE (INITIAL nn NEXT nn)
CHUNK 4
NOCACHE LOGGING
INDEX (TABLESPACE lob_idx_ts
STORAGE (INITIAL nn NEXT nn)
)
我感觉,分开存储除了在批量备份的时候,可能可以提高一点性能(不知道说的对不对),除此之外,还有什么好处?