Post #3912917

@b0rk@social.jvns.ca in large part osmosis from poring over sqlite docs, reading more general database performance guides (like https://use-the-index-luke.com/), and then experimenting a lot with writing more complex queries in some apps I was working on. Having a high-level understanding of how joins are done and how a database uses available indexes helps tremendously. My main us of query planning: answering whether "this query will take forever" or if it will be fast. For my usual work (analytic workloads) there is usually no in-between.