Details

Partitioning for Perf & Management of Large Tables

Speaker: Eddie Wuerch

Duration: 60 minutes

Track: Perf Tuning

Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours?  Come see what partitioning can provide for you.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids