Home » RDBMS Server » Performance Tuning » Assigning intial value to CLOB . will this reduce Fragmentation?
Assigning intial value to CLOB . will this reduce Fragmentation? [message #65632] Wed, 17 November 2004 19:38 Go to next message
ragha
Messages: 3
Registered: December 2002
Junior Member
Hi Everyone,

    Actually we are planning to store XML content in the CLOB column. Initially when u insert a row into the Table the CLOB column will not hold any value. Once the process is done the CLOB column will be updated with the XML Value. So initially while inserting into the Table do we have to assign any default value for reducing the fragmentation on the tables?

Am not sure., Pls clarify.

Thanks  Ragha

 

 

 
Re: Assigning intial value to CLOB . will this reduce Fragmentation? [message #65634 is a reply to message #65632] Wed, 17 November 2004 21:07 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Clobs are stored outside the table once they exceed 4000 bytes.

hth
Re: Assigning intial value to CLOB . will this reduce Fragmentation? [message #65638 is a reply to message #65634] Thu, 18 November 2004 18:22 Go to previous messageGo to next message
lily
Messages: 44
Registered: September 2000
Member
As you have said, Clobs are stored outside the table once they exceed 4000 bytes. Where does it go? As what object? Do they share the same tablespace as the base table?

regards,
Lily
Re: Assigning intial value to CLOB . will this reduce Fragmentation? [message #65639 is a reply to message #65638] Thu, 18 November 2004 20:22 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Read this

hth
Previous Topic: 10046 - Unable to trace JDBC thin client
Next Topic: Reg. ROW Chaining
Goto Forum:
  


Current Time: Fri Mar 29 00:43:35 CDT 2024