On 1 Jun 2010, at 7:11pm, Israel Lins Albuquerque wrote: > About that future release functionality. Will be possible to know whats > temporary index are created? > Using that information will be easy to know what indexes we need create to > increase perfomance, > don't giving chance to sqlite create that indexes!
You can do something pretty good with EXPLAIN QUERY PLAN: http://www.sqlite.org/lang_explain.html I wonder how that could be enhanced to refer to any temporary index created. I understand what Israel wants, I think: CREATE your table with no indices, then ask SQLite what index would be ideal for a SELECT or UPDATE statement. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
