2008-01-16 08:34:59 / Oracle数据库管理
there is an index on check_in_time of table members, check_in_timeis date type.select* from members tWHERE check_in_time = to_date('12/17/2007 10:20:20','mm/dd/yyyy hh:mi:ss');will use index on check_in_time.select* from members tWHERE check_in_time = :3;using bind variable will also use index.but:select* from members tWHERE check_in_time > to_date('12/17/2007 10:20:20','mm/dd/yyyy hh:mi:ss');will always use FTS, even 12/17/2007 10:20:20 is ver
查看(266)
评论(3)