We actually have a requirement to optimize around 6 properties in our implementation layer tables. There properties are coming from our horizontal layer class which points to a different table and that too none of the properties are marked as required in column inclusion.
Is there any way that i optimize all the properties and also populate all the columns?
As discussed the parent table was mapped to default table pr_other and currently expose cols has limitation that the class should not be mapped to pr_other and should have dedicated table. Generally the best practice is to have dedicated table.
Also we have an EPIC (linked to the post above) that was coming up may be we can address this issue in that EPIC.Below are the two solutions that can be considered.
1) Create a same property in the child class with same as parent class. Optimize and delete the property from the child class. (Preferred approach).
2) Map the parent class to dedicated table.Optimize the property and drop the table.
The issue is that the Modify Schema wizard does not show up properties from the parent class as they are not marked as required in Column inclusion. And that too these properties are from our horizontal and hence locked.