1,查询索引:
select * from user_ind_columns a,user_indexes b,where a.index_name = b.index_name and a.table_name = upper('表名');
2,创建索引示例:
create index i_userinfo_userno on userinfo(userno);
1,查询索引:
select * from user_ind_columns a,user_indexes b,where a.index_name = b.index_name and a.table_name = upper('表名');
2,创建索引示例:
create index i_userinfo_userno on userinfo(userno);