Best Practices for Designing Bulk Programs The following are the best practices for this design pattern: Minimize the number of data manipulation language (DML) operations by adding records to collections and performing DML operations against these collections. Minimize the number of SOQL statements by preprocessing records and generating sets, which can be placed in single SOQL statement used with the IN clause.