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!

Is it better to use NUMBER or VARCHAR2 performance wise?

600198Oct 23 2008 — edited Oct 24 2008

Hi,
maybe it's a silly question,
but if i want to save a numeric code in my table is it better to use NUMBER or VARCHAR2, the code will never be use in any calculation.

I'm asking this because i have an idea that is to use NUMBER for a column type only when that value will be used in mathmatic calculations of some sort, if it's not going to be used in calculation i use VARCHAR2.

But other than my choice I've been wondering what is the best choice considering performance.

Can you help?

Best regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2008

Added on Oct 23 2008

13 comments

1,853 views