Performance win or loss for char vs varchar2
Hello!We got an issue were we neeed to choose between char or varchar2 for a column.
The value vill probably be 21 char's of lenght.
Some say that if we know the fixed length for the value choose char.
But some say that it doesn't matter if we go for varchar2 and set it like varchar(50), just to be sure if it will expand.
This table will contain several milions of rows.
What do you think, is there a performance win to choose char instaed of a varchar2(50) for values that probably will just be 21.
All opinions are most welcome!
Best regards
Fredrik
