VARCHAR() Size and Performance?
Many moons ago, I took an Oracle class in college, and I seem to recall my instructor saying that you would get better performance if you choose a VARCHAR() that was certain multiples of whatever.
For example, that VARCHAR(64) would be better than VARCHAR(63) or VARCHAR(65).
Reminder: I am actually working in the MySQL world, and just here to steal knowledge from all of you brainy Oracle people!! :)
As far as I can tell from the MySQL Manual, a VARCHAR() variable - for standard character sets - just takes the String Length and adds 1 Byte.
So, "Debbie" would be 7 Bytes regardless of whether you used a VARCHAR(63), VARCHAR(64) or VARCHAR(65).
How does this work in the Oracle world?
It's probably a petty point in either MySQL or Oracle, but I'm trying to learn how to do things the right way!!
Thanks,
Debbie