Home » SQL & PL/SQL » SQL & PL/SQL » using clob instead of varchar2
using clob instead of varchar2 [message #448510] Tue, 23 March 2010 18:31 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
in our application we are using clob column instead of varchar2 becasue varchar2 does not allow more that 4000 chars, so Using clob allows to put data of any length, will it cause performance issues ? we have this column in almost in all tables, is it recommended ?when is it recomended to use clob ?
Re: using clob instead of varchar2 [message #448515 is a reply to message #448510] Tue, 23 March 2010 22:23 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
if the column needs less than 4000 characters, it would not be wise to use anything other than a
varcahr2.

the clob would just lend additional overhead, being a slightly more "complex" type.


For more reference search On documents And ASKTOM
sriram Smile
Re: using clob instead of varchar2 [message #448537 is a reply to message #448510] Wed, 24 March 2010 00:43 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ Yes but if you need it...
2/ No only when you need it
3/ When you cannot use VARCHAR2

Regards
Michel
Previous Topic: sysdate performance
Next Topic: multiple rows to single
Goto Forum:
  


Current Time: Mon Feb 17 22:22:49 CST 2025