Given a select like this:

select * from ofInterest ;
left join parcels p1 on ofInterest.parcel = p1.fromparcel ;
into table c:\join1

would it speed things up if either of the tables were indexed and on which field? These are both large tables and I'm finding the query takes several minutes to execute. Plus I need to run several iterations of this so it all takes a long time.

Thanks