Probably not what you're asking, but this book is fantastic: https://sql-performance-explained.com/

Edit: and topically, free for the weekend! https://twitter.com/MarkusWinand/status/1199982940471607297