Maintenance overhead increases with the number of indexes. We recommend that you drop unnecessary indexes.
Syntax for dropping an index:
DROP INDEX index_name;
Example:
obclient> DROP INDEX t3_ind2;
Query OK, 0 rows affected (0.02 sec)
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era Join the Event ->
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI.
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era Join the Event ->
OceanBase Database
Download PDF
Maintenance overhead increases with the number of indexes. We recommend that you drop unnecessary indexes.
Syntax for dropping an index:
DROP INDEX index_name;
Example:
obclient> DROP INDEX t3_ind2;
Query OK, 0 rows affected (0.02 sec)