Speed is important step for enterprise solutions and a one table per class strategy is failing to provide these required speed for complex queries.
Solution
In order to optimize the speed of queries, joining with the upper levels of the inheritance structure must be avoided. This strategy is called table per concrete class and all the sub classes must contain the complete set of attributes of the upper leves, also in order to provide fast polymorphic queries the instance must be stored at all the levels.
Introdution
Speed is important step for enterprise solutions and a one table per class strategy is failing to provide these required speed for complex queries.
Solution
In order to optimize the speed of queries, joining with the upper levels of the inheritance structure must be avoided. This strategy is called table per concrete class and all the sub classes must contain the complete set of attributes of the upper leves, also in order to provide fast polymorphic queries the instance must be stored at all the levels.
References