1、oracle创建索引和删除索引

oracle创建索引和删除索引

创建索引

单列索引

create index [indexName] on [tableName]([columnName]);

联合索引

create index [indexName] on [tableName]([columnName1],[columnName2],[columnName3],...);

删除索引

drop index [indexName];

查询某个表中的所有索引

select * from all_indexes where table_name = '[tableName]';

查询某个表建立索引的所有列

select * from all_inx_columns where table_name = '[tableName]';