On 2 Feb 2014, at 1:09am, Keith Medcalf <kmedc...@dessus.com> wrote:
> No access method (yet invented) in any product (yet invented) can use more > than a single traversal path through a collection of data at any given time > during a single traversal operation. Yeah, that's why I asked for a pointer elsewhere in my post. I can't figure out what it does or why it should be worth doing. There are ways to use one index for finding the right rows and another for sorting, but the only explanation of what MS SQL does I can find says it does something like a JOIN. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users