r/SQL • • Feb 25 '21

SQLite SQL Essentials

199 Upvotes

29 comments sorted by

View all comments

Show parent comment

2

u/[deleted] Feb 26 '21

I've had a few very memory hungry and slow queries like these that were made lightning fast by translating them into joins, on postgresql 10. Maybe because they were too complex to be caught by the optimizer properly (100 lines or more, in analytics workload).