Splitting an Entity Horizontally

Defining separate entities for subsets of rows that are part of the same entity can boost performance under certain conditions.

This is true for situations where the following conditions are satisfied:

• The major cause of performance problems is the number of rows a specific entity has
• The entity consists of several distinct subsets of rows and each subset is accessed independently of another.

The following illustration shows a horizontal split of the Company entity on country basis. The split is useful if you are only interested in the companies of a single country.