摘要:
1.唯一索引的创建 create unique index uq_goodsid on goods (goodsid)2.强制使用索引select /*+ index(goods uq_goodsid)*/* from goods3.复合索引的创建create index ind_suid_goodsid on su (suid,goodsid)4.查看索引select * from user_indexes where table_name = 'SU'或者select * from all_indexes where table_name = 'SU'5.重 阅读全文