关于CLOB字段得表,如何设置CLOB存储比较合理

[复制链接]
查看11 | 回复3 | 2011-5-7 01:45:08 | 显示全部楼层 |阅读模式




回复

使用道具 举报

千问 | 2011-5-7 01:45:08 | 显示全部楼层
up
回复

使用道具 举报

千问 | 2011-5-7 01:45:08 | 显示全部楼层
最主要的是
STORE AS ( disable storage in row ) The minimum storage allocation for an out of line LOB is 1 Database BLOCK per LOB ITEM and may be more if CHUNK is larger than a single block. UNDO is only written for the column locator and LOB INDEX changes
STORE AS ( enable storage in row )Allows LOB data to be stored in the TABLE segment provided it is less than about 4000 bytes Both REDO and UNDO are written for in-line LOBS as they are part of the normal row data.
回复

使用道具 举报

千问 | 2011-5-7 01:45:08 | 显示全部楼层
lob 字段可以当作一个段来存储
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行