Make a query more efficient by creating a contact list or a relational table.
When querying against large amounts of data such as email addresses, zip codes, states, or IDs, you can create a contact list or a relational table and use them in your query criteria. The contact list and relational table reduce the chance of producing an error due to prolonged calculation time.
When creating a contact list you can select add contacts from a parent database, based on fields or a query against the parent database, so you can retrieve the IDs, and zip codes that exist in your database.
When you use one or both of these lists in your query criteria, you can update the contact list and relational tables with new contacts and data without having to modify the query.
You can also add or update information in either area by using the following API calls:
- Add a Contact to a Contact List
- Insert and Update Records in a Relational Table