>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

Indexes on ofInterest.parcel and parcels.fromparcel should help a lot.