[Fwd: What is the fastest way to delete duplicate rows from a table?]
This is a multi-part message in MIME format. --------------783CC852D812FA58CAD9426B Content-Type: multipart/alternative; boundary="------------84CFB512024DCAB1747BF195" --------------84CFB512024DCAB1747BF195 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit unload your data , delete it from the table , add a unique constraint in filtering mode (and violation tables) and load your data again. Liat --------------84CFB512024DCAB1747BF195 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <font size=-1>unload your data , delete it from the table , add a unique constraint in filtering mode (and violation</font> <br><font size=-1>tables) and load your data again.</font><font size=-1></font> <p><font size=-1>Liat</font></html> --------------84CFB512024DCAB1747BF195-- --------------783CC852D812FA58CAD9426B Content-Type: message/rfc822 Content-Transfer-Encoding: 7bit Content-Disposition: inline Received: by applicom.co.il id UAA10021 ; Mon, 12 Jun 2000 20:16:24 +0200 (IST) Received: from iiug.iiug.org (www.iiug.org [206.175.175.254]) by black.applicom.co.il (8.9.3/8.9.3) with ESMTP id UAA20049 for <liath@comsoft.co.il>; Mon, 12 Jun 2000 20:14:40 +0200 (IST) Received: (from majordom@localhost) by iiug.iiug.org (8.8.8+Sun/8.8.8) id LAA26423; Mon, 12 Jun 2000 11:10:01 -0500 (CDT) From: strangiato@my-deja.com To: informix-list@iiug.org Subject: What is the fastest way to delete duplicate rows from a table? Date: Mon, 12 Jun 2000 15:22:23 GMT Organization: Deja.com - Before you buy. Message-Id: <8i2v71$80v$1@nnrp1.deja.com> Reply-To: strangiato@my-deja.com X-List-Gateway: comp.databases.informix Sender: owner-informix-list@iiug.iiug.org Precedence: bulk Content-Type: text X-Mozilla-Status2: 00000000 Online 7.x What is the fastest way to delete duplicate rows from a table? I don't really want anything that relies on rowids, because the table may eventually be fragmented. Thanks :) Sent via Deja.com http://www.deja.com/ Before you buy. --------------783CC852D812FA58CAD9426B--