In Salesforce, tracking binary outcomes is often done with boolean fields. However, using a picklist instead offers a blank default, indicating the question wasn’t asked. Picklists also allow more descriptive answers and easier future modifications. Consultants should evaluate data needs before defaulting to booleans.
Salesforce categorizes fields as either indexed or non-indexed, with indexed fields offering faster query execution. System‑generated fields such as lookups, master‑detail relationships, audit dates, and RecordTypeId are indexed automatically. Administrators can manually index custom fields by marking them as External...