Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance between CLOB and VARCHAR2

441000Aug 8 2005 — edited Aug 8 2005
I would like to know if there is any really performance issues between CLOB and VARCHAR2 data types?

In particular, why would it not be better to declare all large text items as CLOB rather than VARCHAR2(4000) in a table? For example, if I am going to store about a page of text, in a table, why not standardize of CLOB? Only use VARCHAR2 for small text items.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2005
Added on Aug 8 2005
1 comment
2,149 views