Running a query with a lot of records

[bigbadbess24]

I am running a query that has over 14000 records. What I tell the query to is read two other queries and tell me which record does not match with the other one. My problem is, that it takes over 10 minutes to do.
I have already compressed the file. I do not have a primary key (trust me on it, I can not do that). Are there any other ways to resolve this?

 

[RV]

Put one or more indices on your tables.
That will speed up your query.

If that doesn't work, I'd opt for an extra coffee

RV