KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table that has a text column Fruit. In that column only one of four values ever appears: Pear, Apple, Banana, and Strawberry. I have a million rows. Instead of repeating that data (on average) a quarter million times each, if I extract it into a another table that has a Fruit column and just those four rows and make the original column a foreign key, does it save space? I expect that the four fruit names are stored only once, and that the million rows now have pointers or indexes or some kind of reference into the second table. If my row values are longer than short fruit names I expect the savings/optimization is even larger.
Tags (comma-separated)
Save Edits
Cancel