I have a few columns that I know won't be used initially. Is it a good practice to add columns only when needed or just leave those extra columns there?
Is it just a little more space in the header or every row?
Depends on the column type to some extent.
Variable sized columns (such as varchar(n)
) will only use 4 extra bytes (approx) per row.
I would add columns only when required, since it is less likely that redundant columns will be added and never removed.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With