How can I see time required to run the query using Sqlite3.exe command
line utility? Is there any way to check if indexes are being used while
running the query and its not doing table scan. I am trying to optimize
the following query
SELECT ID, EventClassName, EventClassRef, TransitionTime, Message,
MonitoredRef, EventRef,ToState,Priority,Acked from Events WHERE
Events.NotificationTime >= {ts '2009-05-04 14:44:10'} Order By ID DESC
LIMIT 100
I have indexes on ID and notificationtime (datatype timestamp).I have
2259207 records in table
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
