[abhishekjha]

Is there a more general reading for software engineers?

Seems like jumping right into the code can be a bit overwhelming if you have no background on the topic.

[sbuttgereit]

Always worth a mention:

https://use-the-index-luke.com/

Markus Winand (the website's author) has also written a book on the subject targeted at software developers which is decent for non-DBA level knowledge.

[orlp]

Not exactly reading but I would recommend the database engineering courses by Andy Pavlo that are freely available on YouTube.

[jmgimeno]

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya and Boris Novikov Anna Bailliekova, published by Apress in 2021.

[rotifer]

You may discover this if you go to the Apress site, but there is a second edition [1] out.

[1] https://hdombrovskaya.wordpress.com/2024/01/11/the-optimizat...

[whiterknight]

https://www.sqlite.org/queryplanner.html