Archive Queries Best Practices

    To improve the success of Archive queries consider the following recommendations:

    • Write conditions on indexed fields. The complexity of the SOQL query has an enormous influence on whether a field is suitable for indexing. Standard and custom indexes are different. Read more here.
    • Reference the SystemModstamp rather than the LastModifiedDate. Read more here.
    • Consider that has its own SOQL query optimizer. Read more here.




    « Previous ArticleNext Article »

    Contact Us

    Sometimes you just want to talk to someone. Our customer support team is available by phone:
    Request a Technical Support Call Back