B*g
2 楼
table里有lob,update(非lob column)performance有多大影响?考虑clob可以
inline。
inline。
v*r
3 楼
$0.02 :->
读入 rows with inline lob, it is roughly like reading in varchar2(4000)
colomn for inline lob column; 读入 rows with outline lob, I/O is more
efficient than other inline clob rows as more outline lob rows can be read
into buffer.
总之,如果是update 非lob columns 的话, lob column 对 performance 影响很小,
很小。
读入 rows with inline lob, it is roughly like reading in varchar2(4000)
colomn for inline lob column; 读入 rows with outline lob, I/O is more
efficient than other inline clob rows as more outline lob rows can be read
into buffer.
总之,如果是update 非lob columns 的话, lob column 对 performance 影响很小,
很小。
相关阅读
HP的这个neoview有没有兄弟有经验oracle database rollback问题Sun buys MySQLAlternative to Embedded SQL for MS SQL ServerMySQL全文搜索的问题why this full-text search doenst work properly?Access question. Pls help.Thx请教一下一个关于SQL SERVER非常基本的问题问个excel得问题 (转载)急,mdb 导到 SQL Server 中 Chinese Character 会是乱码么?请高手指点 怎么建一个傻瓜数据库How to connect Oracle from SQL server management studio?happy new yearsql sever2005SQL Server 卸载的问题。view management问题,谢谢!昨天版主的包子呢?PostgreSQL questionMS SQL database engineer(sr)ONSITE 面试该如何准备?谁有 minibase 的code?