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
From the course: Advanced SQL for Application Development
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.