CHAR vs VARCHAR
I had two columns defined as VARCHAR(50). At that time, I ran the procedure analyze feature and suggested me that I changed them to CHAR(50). However, I created some indexes on these columns. When I reran the procedure analyze, it suggests that I go back with VARCHAR.
My thinking was that CHAR is better than VARCHAR because it's a fixed-size column. I am not worried about disk space - which VARCHAR would win in this case I believe. My only concern is about the performance.
Subject
Views
Written By
Posted
CHAR vs VARCHAR
5648
October 12, 2010 10:08AM
1764
October 13, 2010 05:54PM
1382
November 02, 2010 01:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.