regarding LIMIT your search:
In my experience, if the tables are partitioned, you should first try to use the partitioning columns for filtering.
