What are some useful ways to optimize a query that is suffering due to too many tables?

a year ago
Anonymous $_PGtSJbg8h