| inheritance in table design [message #129819] |
Tue, 26 July 2005 17:39 |
liux99
Messages: 29
Registered: June 2005
|
Junior Member |
|
|
what is the best way to design tables which data has inheritance relationship? It seems to me there are two options out there:
1. put all the attributes in one table, but as the children grows and new attributes add up, the table columns will grow indefinitely, this makes the dml very clumsy.
2. use one base table for the parent class and a separate table for each child class, but this way you most likely will have to make a join to get information, this will slow down the query
i will have very big tables and the query performance is the primary concern, what is your suggestion? or do you have better solution? thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
