Hi community,
I would like to know more about the amount of space next fields take in database (cloud version):
For example, Text(250) field holds a string of 70 characters. How much space would it take in bytes?
What if the value is null?
If we have 20 custom Text columns for Contact object, how much do they affect the performance? For table of 10K-30K rows. And if they are null for bigger amount of contacts?
For the section table (Account, Contact) of 10K-30K rows, what should be... hmm... the strategy of creating new custom fields for better performance? As an option, instead of adding the columns to Contact object we may add them to a separate detail object, but that increases complexity.
Should we consider much about that?
Thank you.