Oracle - Index

oracle

How can we display all the indexes for a given table?

select index_name from dba_indexes where table_name='CMADT_SEARCH';

How can we add index?

CREATE INDEX schemaName.indexName ON schemaName.tableName(columnName1, columnName2);
CREATE [UNIQUE] INDEX schemaName.indexName ON schemaName.tableName(columnName1[, columnName2...])
CREATE INDEX employee_first_last_name_idx ON employee (first_name, last_name);

There are different types of indexes. Need to document this question a bit further.

How can we drop an index?

DROP INDEX [schema_name.]index_name;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License