From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Recommend a table partitioning solution

Recommend a table partitioning solution

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Recommend a table partitioning solution

“

- Welcome back. This is Lesson 1.7, Recommend a table partitioning solution. So, let's talk about table partitioning. Table partitioning is a database process that involves splitting a large table into smaller, more manageable pieces called partitions. Partitioning can improve scalability, reduce contention, and optimize performance. It can also provide a mechanism for dividing data by usage patterns, for example. So, for example, you can archive all our data in cheaper data storage. There's two types of table partitioning. Horizontal partitioning divides a table into multiple tables with the same columns, but fewer rows. Commonly used for large tables with data that can be logically separated by ranges such as dates. The key is to select the correct key on which to partition the data. Then there's vertical partitioning. This splits the table into multiple tables with different columns. This is useful for tables with many columns, especially when some columns are accessed more…

Contents