From the course: Advanced SQL for Application Development

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Overview of partitioning

Overview of partitioning

From the course: Advanced SQL for Application Development

Start my 1-month free trial

Overview of partitioning

- [Narrator] As developers using relational databases for their applications, one thing we need to watch out for is how the growth in the size of our data impacts our application performance. The reason is, is that we add more and more data, the latency or the time required to execute a query can increase. One of the ways we can deal with that is to use a technique called partitioning. There are two kinds of partitioning. One is called horizontal partitioning. Not surprisingly, the other's called vertical. We'll get to that one in a minute. With horizontal partitioning, the basic idea is that when we have really large tables it can be difficult to query those tables efficiently. One of the things we can do is break those large tables into chunks. We call those chunks partitions. With horizontal partitionings, in each chunk we keep a subset of rows. What this allows us to do is basically treat each partition…

Contents