I'm using something like this to create a new table:
CREATE TABLE result AS (SELECT calls.*, targ_with_planned_calls.* FROM calls INNER JOIN planned ON calls.first_id = planned.another_id);
The two tables have around 60k and 80k rows. One table has 5 columns and the other around 15. I'm using AWS RDS db.t2.medium instance. I've let this query run for as long as 10 minutes and it's still going.
Should this be taking so long? I'm wondering what the performance issue is. I would have thought it would be fairly quick.