I'm noticing that the presence of CLOB fields significantly impacts performance when loading a table.
I've got a field being used in memos where the vast majority of the records have fairly small amounts of data in that field. However, there are a handful that are over 4000, making it impossible to use a varchar2 field. So I set it as a CLOB, but that really slows down startup when I open the table. (I do a select * from xxx)
Is there any way to "lazy load" CLOB data until I actually load a specific record? Other than splitting that field into a separate table and explicitly loading it for only that record as it's referenced?
Last edited by David S; 12/20/18 04:25 PM.