开发者

Separate tables for just one field can be logical?

开发者 https://www.devze.com 2023-01-02 19:10 出处:网络
If I have one table which has a City fie开发者_如何学编程ld and as expected this field will repeat itself so only separate it to another table can be ok for normalizing concepts? I mean separated tabl

If I have one table which has a City fie开发者_如何学编程ld and as expected this field will repeat itself so only separate it to another table can be ok for normalizing concepts? I mean separated table who has only one field can be meaningful and can help performance gaining?


It is unlikely to help much. You would need to invent a 'City ID' which would, presumably, be an integer type for cross-referencing to the table of city names. You would complicate the data; when presenting the address information, you'd have to do a join - so simple data dumps would be less readily meaningful (you need two dumps - the main table and the city table - to make sense of a simple data dump).

0

精彩评论

暂无评论...
验证码 换一张
取 消