A用户经常要执行查询: select * from table1 where 输单日期 <= '2008-01-01' and ....B用户经常要执行查询: select * from table1 where 委托日期 <= '2008-01-01' and ....C用户经常要执行查询: select * from table1 where 审核日期 <= '2008-01-01' and ....D用户经常要执行查询: select * from table1 where 统计日期 <= '2008-01-01' and .... 请问是不是都要建立索引 ???
select * from table1 where 输单日期 <= '2008-01-01' and ....B用户经常要执行查询:
select * from table1 where 委托日期 <= '2008-01-01' and ....C用户经常要执行查询:
select * from table1 where 审核日期 <= '2008-01-01' and ....D用户经常要执行查询:
select * from table1 where 统计日期 <= '2008-01-01' and ....
请问是不是都要建立索引 ???