I have a little knowledge about the database and I know how to use JOIN for certain SELECT s. I'm setting up a simple DB where I have absolute assurance that one table has no relation to another. Is required? Is there anything in good practice related to this?
Is it necessary to relate the tables to a database?
3
asked by anonymous 26.09.2018 / 22:10
1 answer
4
No, on the contrary. Just make relationships where you need them. Anything can only be done if you can justify it properly. In fact the most commonly used form of relations is by JOIN and nothing is previously required for it to work. Just make sure you have all the indexes you need to get the best performance.
This would be good practice, although it is best to understand the operation of a database in order to know what to do in all situations.
26.09.2018 / 22:13