create unique index idx_tab_yzh_test_01_01 on tab_yzh_test_01(product_id); create index idx_tab_yzh_test_01_02 on tab_yzh_test_01(product_id,product_no); create index idx_tab_yzh_test_01_03 on tab_yzh_test_01(cust_level); update statistics for table tab_yzh_test_01;
直接删除唯一索引:drop index idx_tab_yzh_test_01_01 ;本回答被提问者采纳