Is it better to have multiple tables?

Question

Having multiple tables is cleaner and probably theoretically better. But when you have to join 6-7 tables to get information about a single user, you might start to rethink that approach. 14 июл. 2009 г.

Why is it better to have multiple separate tables?

In many cases, it may be best to split information into multiple related tables, so that there is less redundant data and fewer places to update.

What's the better database design more tables or more columns?

It's better to have multiple table instead of multiple column and use view if you want to simplify your query. Most of time you will have performance issue with a database it's about network performance (chain query with one row result, fetch column you don't need, etc) not about the complexity of your query.

Can one database have multiple tables?

The majority of databases you'll work with as a developer will have more than one table, and those tables will be connected together in various ways to form table relationships.

Is it used to combine more than one table?

Why using Joins? Joins are used to combine the rows from multiple tables using mutual columns.

Expert · Answer