Oracle Database Discussions

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!

Does column(varchar2) size affects database perfomance?

641060Nov 5 2008 — edited Nov 15 2008

Hi Friends,

I have a table having most of the fields with datatype of varchar2 and size more than 1000. 99% of the scenarios i dont have column values greater than 100 size, but as a precaution i have given more size. Does this affect the performance of the database or allocates more space in tablespace ???......Or is it is fine if i have more column size since it is a varchar2.

Database: Oracle 11g

Need ur advice.

Regards,
Suresh

This post has been answered by JustinCave on Nov 15 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2008

Added on Nov 5 2008

#general-database-discussions

5 comments

15,447 views