On Mar 7, 2:27 pm, "Ed" <e
...@mail.com> wrote:
> create table my_lob_table(f1 int primary key, f2 clob);
> If I know most ("> 80%) of the CLOBs persisted will be bigger than 4K
> should I just specify "DISABLE STORAGE IN ROW" in the creation ?
> thanks
> 10gR2
I would disable storage in the row if the LOB data is not retrieved in
the great majority of cases or if it data beyond 4K is normally
retrieved when the LOB is accessed.
For the most part I always want the entire LOB to be stored external
to the table.
HTH -- Mark D Powell --
