sqlite3数据库查询、索引

select COUNT(*) from SHTwflFault_Info where (endStn_id = 2 and Act_Time_sec > 1318212419 and Act_Time_sec < 1381370820) or (startStn_id = 2 and Act_Time_sec > 1318212419 and Act_Time_sec < 1381370820) GROUP BY FltLine_id

select FltLine_name, FltLine_lev, COUNT(*) AS nums from SHTwflFault_Info where (endStn_id = 2 and Act_Time_sec > 1318212419 and Act_Time_sec < 1381370820) or (startStn_id = 2 and Act_Time_sec > 1318212419 and Act_Time_sec < 1381370820) GROUP BY FltLine_id LIMIT 0, 200
上面两句都执行的很慢，要怎么改或创建索引加快速度呢？QQ：601367847

select COUNT(*) 
from SHTwflFault_Info 
where Act_Time_sec > 1318212419 and  Act_Time_sec < 1381370820
  and (startStn_id = 2 or endStn_id = 2)
group by FltLine_id可以在Act_Time_sec上建索引
第2个sql同第1个，只是后面多了个limit

之前学android开发的数据库时候，用过sqlite3，这是项目里面的一段sql代码，你参考一下 create table moban (_id integer primary key autoincrement, moban_name varchar(40) not null, moban_cost numeric(7,2) not null default 0.00, moban_shouzhi int default 0, moban_delete int not null default 0 moban_beizhu varchar(40) )