News for hackers. Stuff that matters.
Re:SQLite's Automatic Indexes by forinti on Wednesday December 28, 2022 @05:01PM (#34166597)
It might make sense to flag in the metadata that an index might be needed; then again someone using SQLite will probably know very well which queries are being executed.

Also, most of the time joins are made on foreign keys and these should always be indexed. So I guess this should be a rare occurrence if the database is properly thought-out.

There are no comments on this comment yet.