When dealing with subqueries – queries in other queries – try to keep the amount of outcomes they return little. yet again, the specifics will vary dependant upon your RDBMS plus the specifics of one's question, https://www.ralantech.com/database-performance-tuning-and-optimization-company/