1,建立索引
create index goods_num on goods (num) tablespace data;
2,查看表上索引
select * from USER_INDEXES where table_name = 'AA10' (表名大写)
3,根据索引名字查看索引详情
select * from user_ind_columns where index_name = 'PK_AA10' (索引大写)
posted on 2014-11-06 11:17 Java小伙 阅读(98) 评论(0) 编辑 收藏 举报