Fastest way to delete data?

preview_player
Показать описание
If you need to remove rows that are no longer required in your database, there are a lot of options you can explore. But what is the BEST way to do it?

Follow me!

The Podcast!

Subscribe for new tech videos every week

A free Oracle database forever ?! Oh yes indeed!

Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

#database #sql #performance
  1. SQL and Database explained!
  2. oracle
  3. oracle database
  4. asktom
  5. office hours
Рекомендации по теме
How to delete 0:01:37

How to delete multiple files at once on laptop

delete large number 0:01:03

delete large number of files / folders quickly with command prompt in windows 10

delete unwanted data 0:01:47

delete unwanted data at once | MS Excel Tips & Tricks Tutorial

Delete All Data 0:01:23

Delete All Data in a sheet but Keep Formulas | Excel

Delete Temp Files 0:03:18

Delete Temp Files to make your Gaming PC Faster? Fact or Myth?

Delete Empty Rows 0:00:31

Delete Empty Rows at the bottom of your Google Sheet, the easy way

Quickly Delete iPhone 0:00:14

Quickly Delete iPhone Apps for More Storage

How to delete 0:01:36

How to delete temporary files in windows 10

How to Delete 0:00:43

How to Delete Gmail Account Permanently On Android Phone [Quick & Easy] Delete Gmail Account

How to delete 0:02:15

How to delete infinite rows in Excel

How to Delete 0:01:08

How to Delete Everything on your Laptop - Windows 10

How to PERMANENTLY 0:06:22

How to PERMANENTLY delete files so they can't be recovered by people like me!

How To Delete 0:05:30

How To Delete 'Other' Files From Mac

How to Delete 0:01:56

How to Delete Blank Rows in Excel

HOW TO DELETE 0:00:53

HOW TO DELETE HIDDEN TRASH FILES AND FREE UP STORAGE (ANDROID 11)

How to Delete 0:10:57

How to Delete iPhone System Data - Clear Storage!!

How to Permanently 0:06:46

How to Permanently Delete Files on USB Flash Drive

How To Delete 0:02:48

How To Delete iCloud Storage Easily! (2022)

Delete these garbage 0:09:38

Delete these garbage Windows files!

How To BULK 0:07:06

How To BULK DELETE GOOGLE DOCS Files Simple & Easy?

Delete rows with 0:00:51

Delete rows with empty cells in #Excel

How to delete 0:01:07

How to delete a lot of photos in Google Photos quickly

How To Delete 0:02:27

How To Delete Everything From ANY Android Phone! (2021)

How to Delete 0:01:00

How to Delete Files That Cannot Be Deleted

Комментарии
Автор

Hi Connor... please make a detailed video on how to effectively read awr and addm reports.

sumitayadav
Автор

Your last method at the end with MOVE ONLINE is elegant. If that's not possible, a fast solution for an in-place DELETE on large non-partitioned tables is to sort the rows for deletion by DB block ID by using the ROWID, may be using a temp table, and then batch deleting the rows. This reduces the db file sequential reads by clustering by physical location. Linux SD devices and often SAN devices will do a read ahead and pre-cache adjacent data blocks.

steveandreassend
Автор

As always, there is tradeoff, in ordet o move the table and keep the needed rows (assuming we need to delete 20% of the table) we still need almost double the space. however, it is a great option !!!

sagsag
Автор

Hi..can you make a video on varchar 32k. I used in my table and found the row size got increased and the table is largest in db. Is v32k taking lots of space in asm .should i move to clob?

sumitayadav
Автор

Can we use multi threadding. I. e. dividing deleting rows with some logic and distributing to multiple session. Like dbms_parallel_execute where rows are distributed in chunks and each chunk is allocated to each session.

rajaneeshrao
Автор

If we try this out on a 5 TB table and since its online, Database would need additional 5 TB to create a MV in background to support online?

vikram
Автор

Sir, is it true ?


'Bulk collect' is the best approach to delete more a large number of rows efficiently from a table which contains huge amount of data?

siddharthapenchala