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' (索引大写)
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' (索引大写)