Hello,
i'm quite new to programmind with databases...
I'll try to explain my Problem on a symplified example:
I have Two Tables with large amount of data:
CREATE TABLE "tabelle1" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"wert" INTEGER
)
CREATE TABLE "tabelle2" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"wert" INTEGER
)
Both tables have an index:
CREATE INDEX "index1" on tabelle1 (wert ASC)
CREATE INDEX "index2" on tabelle2 (wert ASC)
Then I have a View using these two tables definde like this (PSEUDEOCODE):
SELECT [...] FROM tabelle1
UNION
SELECT [...] FROM tabelle2
When I do a Select on the tables (SELECT * FROM tabelle1) the Index is used,
but when I do a Select on the View (SELECT * FROM myView) , the Index is NOT
used,
so the select takes too much time.
I figured out, that the Problem is the UNION (if I remove the second select,
it seems to work).
So what can I do???
Thank you,
McZerberus
--
View this message in context:
http://www.nabble.com/Indexing-on-UNION-tp20501321p20501321.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
