Olivier Mascia wrote: > 20171201 120319.404 284: automatic index on REMINDER(USER_LOGON) > > Here is that part of the schema: > > CREATE INDEX IX_REMINDER_USER on REMINDER(USER_LOGON); > > Could it be that it might need a DESC index?
Probably not; the index direction usually does not matter. But are you using COLLATE NOCASE (or LIKE)? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users