---
title: "Create and Manage Indexes"
url: https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/indexing/create-manage-indexes/
description: "Catalyst NoSQL is a fully-managed, powerful database that provides you with a non-relational, non-SQL means of data storage. Create, manage, and query data in NoSQL tables with ease, and perform CRUD operations in Java, Node.js, and Python."
last_updated: 2026-08-17T12:16:04Z
service: Cloud Scale
type: general
---

# Create and Manage Indexes

Let's look at creating and working with indexes in your NoSQL table in the Catalyst console.

> **Note:** The configurations made in this section, such as creating and managing indexes, can only be done from the remote console, and not through the SDKs or API. You can perform data operations from the server-side SDKs and API.

### Create an Index

To create an index for a NoSQL table in your project:

1. Navigate to the *Indexes* section of the table from the NoSQL component, then click **Add Index**.

![nosql_create_index](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_create_index_1.webp)

2. Enter a name for the index. You must configure the [*Partition Key*](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#table-keys) for the index by providing a key name and selecting the [data type](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/introduction/#supported-data-types) of the key. 

![nosql_create_index](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_create_index_2.webp)

> **Note:** You will not be able to modify or delete the *Partition Key* of the index, after you configure it. 

3. You can optionally configure a [*Sort Key*](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#table-keys) if you require for the index by selecting **Yes** for "Include Sort Key?". However, if you only prefer having the partition key, then select **No**. If you include a sort key, enter the key name and select the data type of the key.

> **Note:** You will not be able to modify or delete the *Sort Key* of the index, after you configure it.

4. Select an [*Attribute Type*](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/indexing/introduction/#index-types) for the index. 

![nosql_create_index](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_create_index_3.webp)

If you select **Include Columns**, specify the attributes to index. Catalyst will enable you to add multiple attributes in the window. You can click (-) to remove an attribute.

![nosql_create_index](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_create_index_4.webp)

5. After you configure the index, click **Create**.

The index for your NoSQL table will be created and listed in the *Indexes* section. Catalyst will automatically create a **unique Index ID** for your index that you can use to refer it while performing SDK and API actions.

### The Index Section

The *Index* section provides a glimpse of all the indexes configured for a particular table and their details. It displays essential information, such as the unique Index ID, the partition key and sort key configured for it, and the size and the number of items in the index.

![nosql_index.webp](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_index_created.webp)

An empty table will contain 0 bytes and 0 data items. Catalyst operates a built-in scheduler once every 24 hours that calculates and updates the *Storage Size* and *No. of Items* of each index.

For the indexes created for specific attributes, the index section will display a **View** button to display all attributes that are indexed. 

![nosql_index_attributes.webp](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_index_attributes.webp)
 
You can view the attributes by clicking it.

![nosql_index_attributes.webp](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_index_attributes_2.webp)

### Edit an Index 

You can edit an index created for a table in NoSQL to modify the index name. However, you will not be able to modify the partition key, sort key, or attribute types that you configured for it.

To edit the index of a table:

1. Click the ellipsis icon for the index in the *Indexes* section, then click **Edit**.

![nosql_edit_index.webp](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_edit_index_1.webp)

2. Modify the index name, then click **Update**.

![nosql_edit_index.webp](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_edit_index_2.webp)

### Delete an Index

You can permanently delete the index of a table in NoSQL. This will delete it from the storage and you will no longer be able to execute queries based on the index.

To permanently delete an index of a NoSQL table:

1. Click the ellipsis icon for the index in *Indexes* section, then click **Delete**.

![nosql_delete_index.webp](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_delete_index_1.webp)

2. Click **Delete** in the confirmation pop-up.

![nosql_delete_index.webp](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_delete_index_2.webp)