On 5/3/17, Olivier Mascia <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
