【产品名称】
observer
【产品版本】
3.12
【问题描述】
create table h1(c1 int, c2 int, key idx_h1_c1(c1));
create table h2(c1 int, c2 int, key idx_h2_c1(c1));
explain select h1.c1,h2.c2 from h1 ,h2 where h1.c1=h2.c1 ;
explain select /*+index(h2 idx_h2_c1)*/ h1.c1, h2.c2 from h1 ,h2 where h1.c1=h2.c1;
执行结果：h2索引 没使用到呢
预期结果：
