测试数据 select * from student where name='xx' --不走索引 select /*+ index(student ss)*/ * from student where name='xx' --走索引