OPTIMIZATION IN VERY LARGE DATABASES BY PARTITIONING TABLES

Abstract

Very large databases like data warehouse slow down over time. This is usually due to a large daily increase in the data in the individual tables, counted in millions of records per day. How do we make sure our queries do not slow down over time? Table partitioning comes in handy, and, when used correctly, can ensure the smooth operation of very large databases with billions of records, even after several years.

Keywords

• partitioning
• data warehouse optimization
• billions of records
• AdventureWorksDW