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] 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