simple question:
i have table tsamov
create table tsamov (
tsamov_id integer not null primary key
,tsamov_descri text,
,tsamov_code text )
i have index on tsamov_code (it's varchar column of lenght=5)
could the next query use the tsamov_code index ??:
select * from tsamov where tsamov_code like 'AFG%'
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
