can you post the query and some information about the indexes and data distribution in those two tables?