When working with subqueries – queries within other queries – try to keep the number of final results they return tiny. yet again, the details will range based on your RDBMS plus the particulars of the query, https://www.ralantech.com/database-performance-tuning-and-optimization-company/