Re: BLOB fields slow down queries

On Wed, 27 Sep 2006 08:57:35 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>
>Make sure you store the lobs 'out-of-line' in their own tablespace.

To the OP: if you already have the table built, there's no need to recreate the tablespace, BTW. You can move the LOBs with:

ALTER TABLE table_name MOVE LOB(lob_column) STORE AS (TABLESPACE new_ts_name DISABLE STORAGE IN ROW); Received on Thu Sep 28 2006 - 23:36:47 CDT