Loading
About Salesforce Data 360
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Create a Secondary Index

          Create a Secondary Index

          Learn how to create secondary indexes in Data 360 to significantly improve query performance and reduce credit usage on Data Lake Objects (DLOs). Optimize data retrieval beyond primary key fields.

          Required Editions

          Available in: All Editions supported by Data 360. See Data 360 edition availability.
          User Permissions Needed
          To view secondary indexes

          One of these permission sets:

          • Data Cloud User
          • Data Cloud Activation Manager
          • Data Cloud Activation Specialist
          To create or delete secondary indexes

          Permission set:

          • Data Cloud Architect

          To create a secondary index on a DLO, you must have data space access to that DLO. For more information about data space aware objects, see Data Space Aware Objects and Features.

          Use the these steps to create a secondary index.

          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 Data Lake Object (DLO).
          4. Search for and select the DLO that you want to use to create the secondary index.
          5. Choose the field that will be used as the new secondary index and click Save.
            The create workflow showing the second step where the user chooses a DLO and the field to create a secondary index.
          Note
          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.
           
          Loading
          Salesforce Help | Article