VARCHAR vs CHAR Performance

Database
Enthusiast

VARCHAR vs CHAR Performance

On page 885 of the latest Database Design manual it says "When neither CHARACTER nor VARCHAR is clearly a superior choice, use VARCHAR because VARCHAR data requires slightly less CPU resource to manipulate than CHARACTER data."

This is not intuitive and I wonder if anyone can verify or explain this?
Tags (1)
1 REPLY
Enthusiast

Re: VARCHAR vs CHAR Performance

As my own followup, would this change if the VARCHAR were in a PI?