oracle创建索引语句排序,oracle建索引的语句

oracle : 单索引create index 索引名称 on table(column)删除索引drop index 索引名称复合索引create index WBSINDEX ON project_info(wbs,is_delete)查询某张表中所有索引select * from ALL_INDEXS where table_name = project_info查询某张表加了索引的列select * from ALL_IND_COLUMN where table_name = project_info索引优缺点:优点 : 加快查询速度缺点 : 更新,要把索引也进行更新