Re: remove rows that "do not" equal value in column
Posted by:
Rick James
Date: January 20, 2015 05:18PM
Yes, that _may_ be the fastest way. However if you are saving more data than you are deleting, it may not be faster. (It depends on indexes, the phase of the moon, etc.)
If this is to be a recurring event, let's talk about PARTITIONing. (Please explain your use case.)
Subject
Written By
Posted
Re: remove rows that "do not" equal value in column
January 20, 2015 05:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.