Updated on 2025-08-28 GMT+08:00

Deleting an Index

Scenarios

You will delete an index during table creation.

Prerequisites

The index to be deleted has been created and you have not completed the table creation.

Notes and Constraints

You can only delete indexes during table creation.

Procedure

  1. Log in to the KVS console.
  2. In the navigation pane, choose Stores.
  3. Search for and select a store and click Create Table in the Operation column. Or you can click the store name to go to its details page and click Create Table.
  4. Select a billing mode, enter table details, and configure the provisioned read and write throughput (only required for the provisioned billing mode).
  5. In the Secondary Index area, create secondary indexes. KVS allows you to create local and global secondary indexes.

    1. Click Create Local Secondary Index and configure parameters as instructed in Table 1. Confirm the configuration and click OK.
      Figure 1 Local Secondary Indexes
      Table 1 Local secondary index parameters

      Type

      Parameter

      Description

      Create Local Secondary Index

      Name

      Mandatory

      The name of a local secondary index. It must be 1 to 255 characters long. Numbers (0–9), letters (a–z and A–Z), hyphens (-), underscores (_), and periods (.) are allowed. An index name cannot be XPriIndex.

      Sort Key

      Mandatory

      A sort key must be 1 to 63 characters long and cannot start with an underscore (_). Numbers (0–9), letters (a–z and A–Z), hyphens (-), and underscores (_) are allowed.

      Abstract Field

      Optional

      An abstract field in the local secondary index. You can create multiple abstract fields in an index. An abstract field must be 1 to 63 characters long and cannot start with an underscore (_). Numbers (0–9), letters (a–z and A–Z), hyphens (-), and underscores (_) are allowed.

    2. Click Create Global Secondary Index and configure parameters as instructed in Table 2. Confirm the configuration and click OK.
      Figure 2 Global Secondary Indexes
      Table 2 Global secondary index parameters

      Type

      Parameter

      Description

      Create Global Secondary Index

      Name

      Mandatory

      The name of a global secondary index. It must be 1 to 255 characters long. Numbers (0–9), letters (a–z and A–Z), hyphens (-), underscores (_), and periods (.) are allowed. An index name cannot be XPriIndex.

      Shard Key

      Mandatory

      A shard key must be 1 to 63 characters long and cannot start with an underscore (_). Numbers (0–9), letters (a–z and A–Z), hyphens (-), and underscores (_) are allowed.

      Sort Key

      Optional

      A sort key must be 1 to 63 characters long and cannot start with an underscore (_). Numbers (0–9), letters (a–z and A–Z), hyphens (-), and underscores (_) are allowed.

      Read Throughput

      Value range: 1 to 50000 (unit: RCU) This field is only valid in the provisioned billing mode.

      Write Throughput

      Value range: 1 to 50000 (unit: WCU) This field is only valid in the provisioned billing mode.

      Abstract Field

      Optional

      An abstract field in the global secondary index. You can create multiple abstract fields in an index. An abstract field must be 1 to 63 characters long and cannot start with an underscore (_). Numbers (0–9), letters (a–z and A–Z), hyphens (-), and underscores (_) are allowed.

  6. In the Secondary Index area, locate the index to be deleted and click Delete in the Operation column.

    Figure 3 Deleting an index