How to optimize your Selection in DESelect Segment?

a poorly constructed selection can lead to time outs multiple factors might cause this including the length and complexity of the selection, and the volume of data in this article, we will provide you with tips and best practices on how deselect users can optimize their selections optimization tips use a predicate primary key on your data extensions this will be a great help when running your selection that involves combined or joined data extensions use only the necessary fields from available data extensions to your target data extensions instead of selecting all fields this will lead to less data population use proper field types for example, define a text field as a text data type or a number field using the number data type do not store numbers as text unless you plan to combine or join them with data views since they are usually stored as text data type in sfmc define target data extension fields' maximum length property based on the maximum size of data to be stored in them for example, if you always store a five digit customerid then limit the field length to five characters use correct filter types for example, instead of selecting multiple fields and use equals filter type to match multiple values, use an in filter type to select only one field and separate the values using a comma as a separator use equals filters instead of contains if you can, as contains leads to slower performance use as few data extensions as possible under selection criteria ensure that the customer key length of the data extension you are using is within sfmc recommended length (36)