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