I don't really understand what you are asking, but I suspect that
http://www.sqlite.org/withoutrowid.html is probably the answer you are
looking for.
On Fri, Oct 31, 2014 at 8:15 AM, Hick Gunter <h...@scigames.at> wrote:
> Can you give an example of what such a beast would look like?
>
> CREATE TABLE not_exist (A, B, C, D, E); -- for illustrative purposes
> CREATE INDEX no_table ON not_exist (A,B,C,D,E); -- has to be covering index
>
> The only efficient order to return and/or select rows is by {A}, {A,B},
> {A,B,C}, ...
>
> All other selects need to perform a full table/index scan, e.g. SELECT ...
> WHERE C=15;
> All other orders need to perform a sort, e.g. SELECT ... ORDER BY C;
>
> -----Ursprüngliche Nachricht-----
> Von: Paul [mailto:de...@ukr.net]
> Gesendet: Freitag, 31. Oktober 2014 11:30
> An: General Discussion of SQLite Database
> Betreff: [sqlite] Index without backing table
>
> Is there a way to have index without table?
>
> Is it possible to achieve this with virtual talbe tricks but without
> implementing B-tree myself?
>
> I need this both for space effciency and to minimize disk I/O (by avoiding
> table updates).
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___________________________________________
> Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> FN 157284 a, HG Wien
> Klitschgasse 2-4, A-1130 Vienna, Austria
> Tel: +43 1 80100 0
> E-Mail: h...@scigames.at
>
> This communication (including any attachments) is intended for the use of
> the intended recipient(s) only and may contain information that is
> confidential, privileged or legally protected. Any unauthorized use or
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please immediately notify the sender
> by return e-mail message and delete all copies of the original
> communication. Thank you for your cooperation.
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
