Hi,

What constraints should be kept in mind while deciding whether to use a single Table in inheritence (using a discriminator) and single table per subclassing.

Any advice?

Thanks in advance.

Main disadvantage of the table-per-class hierarchy strategy is that columns specific for subclass must be nullable, but this strategy performs better than tabe-per-subclass strategy. Main disadvantage of the tabe-per-subclass strategy is that it uses additional join wich may affect on perfomance.