Details

Partitioning for Perf and Mgmt of Large Tables

Eddie Wuerch
60 minutes
Track 2
Intermediate
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 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