Re: Indexing a CLOB
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Fri, 13 Feb 2009 22:22:34 +1100
Message-ID: <499557FA.6070408_at_iinet.net.au>
Just a small warning regarding out of line CLOBs: with 8k blocks, they are stored one per block. Even if their length is way smaller than the 4k boundary for a CLOB to migrate out of line.
So, if you have 30 million rows in a table, you better be prepared for 30 million blocks of out-of-line CLOB storage, at a minimum. DAMHIKT...
Date: Fri, 13 Feb 2009 22:22:34 +1100
Message-ID: <499557FA.6070408_at_iinet.net.au>
Just a small warning regarding out of line CLOBs: with 8k blocks, they are stored one per block. Even if their length is way smaller than the 4k boundary for a CLOB to migrate out of line.
So, if you have 30 million rows in a table, you better be prepared for 30 million blocks of out-of-line CLOB storage, at a minimum. DAMHIKT...
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au japplewhite_at_austinisd.org wrote,on my timestamp of 13/02/2009 6:42 AM:Received on Fri Feb 13 2009 - 05:22:34 CST
> highly recommend using out-of-line CLOBs - you have more options for
> placing the CLOB segments and keeping your base table lean and fast wrt,
> say, full table scans.
-- http://www.freelists.org/webpage/oracle-l