Need to remove unused fields from Record type.

Question

Can anyone help me on this : -

You need to remove an unused field from an existing record type Product, which has data sync enabled and is backed by a database table. What should you do?

A. Delete the field from the record type and optionally delete the column from the database table. 
B. Delete the field from the product Custom Data Type (CDT) and perform a full resync of the record type.
 C. Delete the column from the database table and perform a full resync of the record type.

shubhama926776 · Accepted Answer

Hello [mention:05ec0292a76349c3b810baa88e2b75f7:e9ed411860ed4f2ba0265705b8793d05]

The correct option is A. Delete the field from the record type and optionally delete the column from the database table.
To remove an unused field from a data-synced record type, delete the field directly from the record type. Optionally, you can also delete the corresponding column from the database table for better database hygiene.

karumurua531442 · Answer

hi,[mention:05ec0292a76349c3b810baa88e2b75f7:e9ed411860ed4f2ba0265705b8793d05]  Unused fields in a database don't directly cause performance issues since you wouldn't be writing or reading from that field we might have to think regarding efficiency in the long run. May vote for option C. That both the record type and the database schema remain synchronized. This approach eliminates the unused field from the record type and also in the database table and also has consistency in both the record and db.

Sign up

Login with SSO

Login to the community

Login with SSO