现有一个索引:isextract,ishulue,isignore
还有几条sql语句:
1、select * from yuqing where isignore=0 and ishulue =0 and isextract='tjf' order by generatetime;
2、select * from yuqing where isignore=0 and state=0 and isextract='tjf' order by generatetime;
3、select * from yuqing where isignore=0 and state=0 and ishulue =0 and isextract='tjf' order by generatetime;
4、select * from yuqing where isignore=0 and isextract='tjf' order by generatetime;
以上4条sql语句哪几条用到索引的啊?
我想尽量少的建索引,应该怎么建啊?
谢谢...
还有几条sql语句:
1、select * from yuqing where isignore=0 and ishulue =0 and isextract='tjf' order by generatetime;
2、select * from yuqing where isignore=0 and state=0 and isextract='tjf' order by generatetime;
3、select * from yuqing where isignore=0 and state=0 and ishulue =0 and isextract='tjf' order by generatetime;
4、select * from yuqing where isignore=0 and isextract='tjf' order by generatetime;
以上4条sql语句哪几条用到索引的啊?
我想尽量少的建索引,应该怎么建啊?
谢谢...
解决方案 »
- 本地动态能写这个吗?
- oracle function 写法
- SQL2中多表连接的问题,高手才进!
- oracle数据库表误更新,之前未备份。有什么其他的回复数据的实用办法?
- 我要在hp-ux11iV3下安装oracle10g(10.2.0.1),但不懂具体要打什么补丁,请问去哪获得该要打什么补丁呢?
- 急急急急急急急急急急急 数据插入问题 有点麻烦 高手赐教 谢谢
- 求助,这条语句怎样修改,可以在Oracle中执行?
- 为何不能进入oracle mangment server?
- 希望不至于要我重装ORACLE!!
- 关于存储过程的怪事.通过存储过程insert的记录刷新一下就没了.
- 菜鸟求助
- 求教一个方法
set autotrace on