By default, all constraint relationships within an entity are major. This can sometimes result in including excess data in the subset, when you run a subset operation. Optimize the relations such that the entity has a minimum number of major relations to ensure the subset operation fetches minimal data while considering all tables in the entity. You can also optimize relations at run time in a plan. When you optimize relations at run time, you do not save the changes to the entity.