Home » RDBMS Server » Performance Tuning » Deleting duplicate rows without subquery
Deleting duplicate rows without subquery [message #183828] Mon, 24 July 2006 01:37 Go to next message
a_developer
Messages: 194
Registered: January 2006
Senior Member
Is there a way to delete duplicate rows of a table without using a subquery? When we used subquery, performance becomes slow..
Re: Deleting duplicate rows without subquery [message #183852 is a reply to message #183828] Mon, 24 July 2006 02:54 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a temporary table as SELECT DISTINCT ... from the original table; drop the original table; rename temporary table to original table name.
Re: Deleting duplicate rows without subquery [message #184183 is a reply to message #183828] Tue, 25 July 2006 11:33 Go to previous message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
Well it should not be a problem if you are using rowid. I guess you are using rowid to delete duplicates.
Previous Topic: RBO to CBO Conversion
Next Topic: Help in Performance issue problem
Goto Forum:
  


Current Time: Thu Dec 08 22:06:00 CST 2016

Total time taken to generate the page: 0.14040 seconds