Re: [sqlite] create index on view

Hi Tom Thanks. Here you go:- CREATE TABLE Table1 (A INTEGER ,B INTEGER) (10 rows) CREATE TABLE Table2 (A INTEGER ,B INTEGER, C TEXT, D TEXT) (100 rows) CREATE TABLE Table3 (A INTEGER ,B INTEGER, C TEXT) (50 rows) Create Index X1 on Table1 (A, B) Create Index X2 on Table2 (A, B) Create Index X

[sqlite] create index on view

Hi May I know if we can create index on a View? Otherwise, is there any recommendation to speed up the query involving join between two Views? Thanks in advance. wying ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/

[sqlite] create indexed view

Hi May I know if we can create index on a View? Thanks in advance. wying ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] create indexed view

Hi May I know if we can create index on a View? Thanks in advance. wying ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users