Forum Stats

  • 3,836,885 Users
  • 2,262,201 Discussions
  • 7,900,133 Comments

Discussions

Delete a large amount of data on Partition

User_SWR12
User_SWR12 Member Posts: 17 Red Ribbon

Hi

I'm trying to delete a high number of records from a partition table for that I'm using the following command.

DELETE FROM tab PARTITION (P_082020);

The problem is that it takes too long.

Can you help me to find the best way to delete records from a table with millions of records without having to recreate it?

Answers