01-24-2016, 05:31 PM
The databases don't really work like that. They are like creating tables in Excel, (or Access, to be more accurate, but less people are familiar with that one). Adding a new column effects every row of data automatically and can't be avoided. And leaving the data in that column blank for most rows would be pointless, as you'd have to code the searches to say "if this variable is blank, then check the other variable", which results in more time to return results. The fastest method is to simply have something in each line of the column for the search to read, even if it's redundant, which results in a heavier database but faster processing.