I have a need to set a field, Account.Previous_Owner_Id__c, which will store the 18 characters Id of the User who used to be the previous owner of the account.
- If we create this field as a lookup field to reference the User object, is there any overhead added to the system? For example, having an additional lookup field makes the SOQL queries longer to load even when the field isn't referenced in the
SELECTportion of the query.
- Would it be better to just use a 18 character Id field as a text field?