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
