Dear,
On such a log line as:
automatic index on REMINDER(USER_LOGON) (284)
I understand what it means and what I might want to do (or not).
Though what should I understand from line like these:
automatic index on sqlite_sq_25FA456860(ID) (284)
automatic index on sqlite_sq_25FA455E40(ID) (284)
automatic index on sqlite_sq_25FA456C50(ID) (284)
automatic index on sqlite_sq_25FA455ED0(ID) (284)
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?
(I have no apparent problem / issue. Just pinpointed these in the log.)
--
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia, http://integral.software
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
