Techniques used to identify and improve query performance found in the following ServiceNow article https://www.servicenow.com/community/developer-articles/database-performance-improving-slow-or-and-join-queries/ta-p/2299441