查询表中所有的索引,一般情况下,oracle是不管大小写的,但上面查询语句里面的table_name必须大写,如果写成‘picture’则是没有记录
select index_name from all_indexes where table_name = ‘PICTURE’;
创建索引
create index picture_album_idx on picture (aid);
create index picture_user_idx on picture (userid);
create index picture_cat_idx on picture (cid);