Hi,
Simplified example :
Table t1
(
col1 number primary key
,col2 varchar( 50 )
,col3 number
)
select
min( col3 )
fro
t1
;
explain plan :
order from detail
0 0 TABLE t1 WITH INDEX idx_t1_col3 ORDER BY
select
min( col3 ) + 1
fro
t1
;
order from detail
0 0 TABLE t1
Why the second case cannot use index idx_t1_col3 ?
How i can force the query to use the index ?
In the real case the query is :
select
col2
from
t1
where
col3 = (
select
min( col3 ) + :delta
from
t1
)
;
I don't know the explain plan with bind variable.
Thanks.
--
Philippe.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
