Re: [sqlite] selecting an indexed table
Alex Katebi wrote: > I have no way of knowing which rows a select command has visited for an > indexed table. > > create table t(a); > create index it on t(a); > insert ... > select * from t where a=5; > > Is there a select hook for debugging? How about: explain select * from t where a=5; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] selecting an indexed table
I have no way of knowing which rows a select command has visited for an indexed table. create table t(a); create index it on t(a); insert ... select * from t where a=5; Is there a select hook for debugging? Thanks, -Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users