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
);