如何优化数据库中的查询 - 基础知识

It seems that all questions regarding this topic are very specific, and while I value specific examples, I'm interested in the basics of SQL optimization. I am very comfortable working in SQL, and have a background in hardware/low level software.It seems that all questions regarding this topi