Re: SQL Select taking forever

Could it be worth splitting your INSERT-SELECT into two. The first as you have it but without the outer join which will avoid using the index properly. The second to catch all the outer-joined records (using a NOT IN construct?). You should be able to write these using the primary key indexes and may take less time.

HTH --
Alan D. Mills

To email remove NOSPAM from address. Received on Wed Jun 17 1998 - 09:34:30 CDT