Prerequisite Tree for Make a Slow SQL Query Fast: Read the Execution Plan, Fix the Index, Rewrite the Query

Building prerequisite diagram…

Large diagrams can take up to 20 seconds to lay out in some browsers (e.g. Safari Lockdown Mode).