---
schema_version: "1"
id: cf6f5b3d5ddd416abe098f66ec499012a78d79483cf6926419e402d82622a9a5
title: Create a Secondary Index
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_query_create_secondary_index.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_query_create_secondary_index.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e06fc172b21a2a4fcbbe83ef5b971291c8def29c2899445a5052c5ae90eb665e
description: Create secondary indexes in Data 360 to improve query performance and reduce credit usage on data lake objects (DLOs) or materialized data model objects (DMOs) by optimizing data retrieval beyond primary key fields.
products:
  - Data 360
release: "264"
---
# Create a Secondary Index

Create secondary indexes in Data 360 to improve query performance and reduce credit usage on data lake objects (DLOs) or materialized data model objects (DMOs) by optimizing data retrieval beyond primary key fields.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>All Editions</strong> supported by Data 360. See <a href="https://help.salesforce.com/s/articleView?id=data.c360_a_dc_editions.htm&amp;release=264.0.0&amp;type=5" title="Data 360 is available in several supported Salesforce editions. Some Data 360 features also require additional licenses.">Data 360 edition availability</a>.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:left;vertical-align:top;" id="d106650e72">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d106650e72 ">To view secondary indexes</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d106650e72 ">
              <p>One of these permission sets: </p>
              <ul>
                <li>Data Cloud User</li>

                <li>Data Cloud Activation Manager</li>

                <li>Data Cloud Activation Specialist</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d106650e72 ">To create or delete secondary indexes</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d106650e72 ">
              <p>Permission set: </p>
              <ul>
                <li>Data Cloud Architect</li>

              </ul>
            </td>

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

To create a secondary index on a DLO or DMO, you must have data space access to that object. For more information about data space aware objects, see [Data Space Aware Objects and Features](https://help.salesforce.com/s/articleView?id=data.c360_a_data_space_aware_features.htm&release=264.0.0&type=5 "User access to data space-aware objects and features is controlled by setting the object permissions and feature permissions in the user's permission sets. Not all objects and features are data space aware.").

1. In Data Cloud, navigate to **Secondary Indexes** tab.
    1. From the App Launcher, find and select Data Cloud.
    2. Select the **Secondary Indexes** tab if it's available. Otherwise, choose **More** and select **Secondary Indexes**.
2. Choose **New** on the Secondary Indexes page to open the **New Secondary Index** window.
3. Enter a **Name** for your new secondary index and optionally provide a **Description**.
    
    Ensure that the name of your secondary index is descriptive and provides context that it is an index. Secondary indexes are saved as a new DLO.
4. Search for and select the DLO or materialized DMO that you want to index.
    
    Search by object name or browse available objects.
5. Choose the field to use for the secondary index, and then click **Next**.
    
    ![The Indexed Field step of the New Secondary Index window, showing the object list and the table of fields with a field selected.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/data_cloud/images/secondary-indexes.png)
6. Set a refresh rate for your index, and then click **Save**.
    
    Select a **Frequency** of **Hourly**, **Daily**, or **Weekly**, and set the **Daily Start Time** and **Time Zone**. For an hourly or daily refresh, set **Run Every**. For an hourly or weekly refresh, also select one or more **Scheduled Day(s)**.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png)

Note You can't edit secondary indexes after creation. To change a secondary index, delete and recreate it. Recreating a secondary index incurs the cost of index creation. You can change how often the index refreshes at any time. See [Schedule a Secondary Index Refresh](https://help.salesforce.com/s/articleView?id=data.c360_a_schedule_secondary_index_refresh.htm&release=264.0.0&type=5 "Set how often Data 360 refreshes a secondary index so that the index stays current with the underlying object. Choose a refresh frequency that keeps the index fresh enough for your queries without refreshing more often than your data changes.").