On 5/3/17, Olivier Mascia <o...@integral.be> wrote: > automatic index on sqlite_sq_25FA4563E0(ID) (284) > ... > > I guess they mean SQLite decided to build some temporary index for some > query execution, just as for the first case. But here the table itself looks > like internal and temporary. What can I interpret from these?
Yes. Those sqlite3_sq_... tables are going to be materializations of views and/or subqueries. The "sq" stands for "subquery". -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
