Hi, ALL,
Looking at http://www.sqlite.org/eqp.html#section_1_2 it would be nice to
mention in which case B-Tree is unavoidable.

Only one use case with B-Tree vs indexing is used but from reading first
paragraph it looks like indexing is B-Tree replacement everywhere.

I have a query with ORDER BY and creating an index did not help. EXPLAIN
QUERY PLAN still used B-TREE.

It might help other people in the same situation.

Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to