Just to complete the thread. Ross
----- Forwarded message from "Zhang, Anna" <[EMAIL PROTECTED]> ----- From: "Zhang, Anna" <[EMAIL PROTECTED]> To: "'Ross J. Reedstrom'" <[EMAIL PROTECTED]> Subject: RE: [ADMIN] tuning SQL Date: Tue, 29 Jan 2002 14:08:53 -0500 Return-Receipt-To: "Zhang, Anna" <[EMAIL PROTECTED]> X-Virus-Scanned: by AMaViS snapshot-20010714 I had same thought as you. select into temp table only took a minute, then insert into contact took 1 hour. Thanks! Anna Zhang -----Original Message----- From: Ross J. Reedstrom [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:46 PM To: Zhang, Anna Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] tuning SQL So, how long does the just the select take? You might be running into something odd with selecting from and inserting into the same table: I'm not sure of the visibility rules here. You might be better off selecting into a new temp table (see: SELECT INTO) then inserting from that. Ross ----- End forwarded message ----- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
