I am running queries on two large tables, both have indexes on the fields in the where clause. I have 7 mil records in one table and 10 mil in the other.

Are there any tricks to speed this up?

What about any adjustments on my pc?

Thanks, Chris