I have 3 SQL queries (MySQL) which are taking a while to run when the tables they are based on have many records. I need these queries to be optimized as much as possible to return results very quickly. The queries are about 20 lines of code in total.
I will not be able to provide you with a copy of the database. But I will be able to provide you with create table scripts for the required tables.
Please ONLY respond if you are a very experienced DBA or query optimizer. Thanks.