>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

1. Do you need all the fields from both tables?

2. Yes, you need indexes on Parcel and FromParcel fields in OfInterest and Parcels table correspondingly.