On 3/27/16, David Rayna <drayna at optonline.net> wrote: > I got excited when I saw the "indexed by" clause. > A technique I used years ago with FoxPro & etc was to allow each user to > create his own personal index of the same data.
That's not what INDEX BY does. An you cannot really give each user their own private index, because if user A inserts new data, then the new content would not appear in user B's index, which user A knows nothing about. -- D. Richard Hipp drh at sqlite.org