OraFAQ Forum: Performance Tuning » Deleting duplicate rows without subquery

Home » RDBMS Server » Performance Tuning » Deleting duplicate rows without subquery

Mon, 24 July 2006 01:37

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..

Mon, 24 July 2006 02:54

Littlefoot
Messages: 21808
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.

Tue, 25 July 2006 11:33

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 Apr 25 22:02:56 CDT 2024