---
schema_version: "1"
id: 4933c2b437a49caa45f541684702d1b998dac6f51bbc680a9ae8cb13ac0e2660
title: Database Query Limits and Guidelines
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_overview_limits_queries.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_overview_limits_queries.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5c432db7347094092fa815de1d7a3400f7a792ff1ef22b9bd04a3633f1a8a273
description: "Query limits protect the health and performance of the Marketing Cloud Engagement database. There are two types of limits: hard and soft. If you issue a query that exceeds a hard limit, the request is rejected. You can exceed a soft limit, but doing so can degrade performance. Salesforce reserves the right to limit the execution of queries that exceed soft limits if they cause system performance or security issues."
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Database Query Limits and Guidelines

Query limits protect the health and performance of the Marketing Cloud Engagement database. There are two types of limits: hard and soft. If you issue a query that exceeds a hard limit, the request is rejected. You can exceed a soft limit, but doing so can degrade performance. Salesforce reserves the right to limit the execution of queries that exceed soft limits if they cause system performance or security issues.

These limits apply to queries issued using APIs and through the web interface.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:19.455252918287936%">
          <col style="width:21.78988326848249%">
          <col style="width:23.540856031128403%">
          <col style="width:35.21400778210116%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d67010e45">Resource</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d67010e48">Limit</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d67010e51">Limit Type</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d67010e54">Details</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Resource" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">Maximum number of queries that can be run per day for a single enterprise ID
              (EID)</td>

            <td data-label="Limit" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">
              <p>The limit depends on your edition.</p>
              <ul>
                <li><strong>Pro</strong>: 100 queries per day</li>

                <li><strong>Corporate</strong>: 1,000 queries per day</li>

                <li><strong>Enterprise</strong>: 3,000 queries per day</li>

              </ul>
            </td>

            <td data-label="Limit Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">Soft limit</td>

            <td data-label="Details" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">—</td>

          </tr>
          <tr class="">
            <td data-label="Resource" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">Maximum run time for a single query</td>

            <td data-label="Limit" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">30 minutes</td>

            <td data-label="Limit Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">Hard limit</td>

            <td data-label="Details" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">For best performance, reduce the scope of your queries so that they finish in less
              than 5 minutes.</td>

          </tr>
          <tr class="">
            <td data-label="Resource" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">Data extensions operated upon in a single query</td>

            <td data-label="Limit" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">5 data extensions</td>

            <td data-label="Limit Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">Soft limit</td>

            <td data-label="Details" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">For best performance, operate on 4 data extensions or fewer per query.</td>

          </tr>
          <tr class="">
            <td data-label="Resource" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">Rows in a data extension</td>

            <td data-label="Limit" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">20 million rows</td>

            <td data-label="Limit Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">Soft limit</td>

            <td data-label="Details" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">—</td>

          </tr>
          <tr class="">
            <td data-label="Resource" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">Number of joins per query</td>

            <td data-label="Limit" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">4 joins</td>

            <td data-label="Limit Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">Soft limit</td>

            <td data-label="Details" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">For best performance, limit each query to 3 joins or fewer.</td>

          </tr>
          <tr class="">
            <td data-label="Resource" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">Number of overwrites per automation</td>

            <td data-label="Limit" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">5 overwrites</td>

            <td data-label="Limit Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">Soft limit</td>

            <td data-label="Details" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">—</td>

          </tr>
          <tr class="">
            <td data-label="Resource" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">Number of queued data extracts</td>

            <td data-label="Limit" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">250 extracts</td>

            <td data-label="Limit Type" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">Hard limit</td>

            <td data-label="Details" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">If 250 or more data extracts are queued in a single Member ID (MID),
              subsequent data extract requests are rejected.</td>

          </tr>
          <tr class="">
            <td data-label="Resource" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e45 ">&nbsp;</td>

            <td data-label="Limit" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e48 ">&nbsp;</td>

            <td data-label="Limit Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e51 ">&nbsp;</td>

            <td data-label="Details" class="slds-cell-wrap" style="vertical-align:top;" headers="d67010e54 ">&nbsp;</td>

          </tr>
        </tbody>
      </table>