oracle索引查询
/*<br>*
*查看目标表中已添加的索引
*
*/
--在数据库中查找表名
select
*
from
user_tables
where
table_name
like
'tablename%'
;
--查看该表的所有索引
select
*
from
all_indexes
where
table_name =
'tablename'
;
--查看该表的所有索引列
select
*
from
all_ind_columns
where
table_name =
'tablename'
;
/*
*创建索引
*
*/
create
index
idx01 tablename(
column
);