On Tue, Jun 01, 2010 at 02:13:06PM -0400, Richard Hipp scratched on the wall: > On Tue, Jun 1, 2010 at 2:09 PM, Israel Lins Albuquerque < > israel...@polibrasnet.com.br> 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!
> No. Unfortunately we do not have any mechanism to tell you what indices > were created. There is a mechanism to alert the application to the fact > that transient indices were creating for a particular query, as a hint to > the developer to go back and think more about indices on that query. But it > does not provide any suggestions on what indices would be useful. I also assume the query optimizer may create an index on a transient set (or "materialized table" in some books) that might not exist as an actual table. If that's true, there may not be any standard index that can be created. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users