db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com>
Subject Re: Determine which child table a record belongs to
Date Tue, 29 Jan 2008 22:30:10 GMT
On Wednesday 30 January 2008 05:28:14 Craig L Russell wrote:
> The alternative is to include all possible tables in a query, which is
> performance-limiting.

Another alternative is to use single table inheritance, where you still have a 
type column but also put every field from every class into the one table and 
just don't fill out the ones which don't make sense for a given type.  Rails 
developers are very fond of this strategy.

Daniel

Mime
View raw message