Forum Stats

  • 3,851,945 Users
  • 2,264,053 Discussions
  • 7,904,914 Comments

Discussions

delete rows issue

sdk11
sdk11 Member Posts: 76
edited Apr 9, 2011 1:59AM in Advanced Compression
Hi,

What are the best ways to delete few million rows from a table keeping the table available for the loads and customer access? This table has 50 million rows, and I need to retain few months’ data and delete the rest. Please let me know if you have any ideas

Thanks

Answers

  • 830387
    830387 Member Posts: 2
    If its one time activity do it with plql with few thousand row commited so you dont generate more undo ,
    If its repeative process partition the table based on the numbers of rows which gets partitioned to partition or partitions .
    Then just drop or truncate the partition that will be faster and efficient
    Yes when you partition make sure you are able to achieve the performance same by testing the queries normally run againt the table in Test database
    seatch asktom/this forum which has examples for similar questions
This discussion has been closed.