how to delete rows from large table

Solution depends on the following:

  1. Space availability?
  2. Is table partitioned?
  3. What percentage of the table will be deleted?
  4. Number of indexes?
  • Solution based on CTAS (create temporally table):

CREATE TABLE <temp table> AS

SELECT *

FROM <source table>

WHERE <filter>

;

DROP <source table>;

RENAME < temp table> to <source table>;

  • Solution based on rowid and blocks:

< in progress>


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s