Hi wying, > 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?
No you can't create an index on a view, but you can create an index on the underlying tables that the view uses. Two preliminary suggestions: 1. Stop repeating the same question. 2. Post the schema of your tables and views and the query. Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users