shuaisam

摘要： 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.重 阅读全文