Hi P, thanks, I had considered that.
Hope there is another solution though. Günther P Kishor schrieb: > On 10/13/08, Guenther Schmidt <[EMAIL PROTECTED]> wrote: > >> Hi, >> >> unfortunately I've hit a point where I run a query where one VIEW joins >> another VIEW. >> >> Both views are rather large and since there is no index on the fields >> where they join the query takes very very long. (About 15 min). >> >> Does anybody here know a solution to this problem? >> > > create temporary tables with the views, possibly index these temp > tables, then query that table. > > >> Best regards >> >> Günther >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users