[Oralce] 如果要看测试计划,就不要在SQL中输入””作为参数

比如说,

   如果要看 select * from people where id= ”的测试计划, oracle会告诉你它使用了全表扫描,即使id这个字段上有索引。

  而这样就不会全表扫描了: select * from people where id= ‘234’

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.