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
s
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;
_
2 matches
Mail list logo