1
00:00:00,060 --> 00:00:00,600
‫Beautiful.

2
00:00:01,200 --> 00:00:02,370
‫So that's that's partitioning.

3
00:00:02,550 --> 00:00:10,770
‫So let's discuss vertical versus horizontal partition, horizontal partition is splitting that the partition

4
00:00:11,250 --> 00:00:17,250
‫biros, as we discussed in this case, where customers from this rows to this to this idea, to this

5
00:00:17,250 --> 00:00:22,590
‫idea as and this partition and other customers from this idea to this idea, is this what we are splitting

6
00:00:22,590 --> 00:00:25,020
‫biros like almost like horizontally?

7
00:00:26,160 --> 00:00:28,250
‫Imagine this is like a knife, right?

8
00:00:28,260 --> 00:00:34,320
‫It's like slicing in the middle, despising the table in the middle and then breaking the partitions

9
00:00:34,320 --> 00:00:35,220
‫into multiple ones.

10
00:00:35,610 --> 00:00:37,420
‫So that's that's the partition.

11
00:00:37,420 --> 00:00:44,010
‫And there is like types of partition, like by rangers' like we did or less zipcode or nine or two or

12
00:00:44,010 --> 00:00:50,820
‫five is on this table or partition zipcode nine one one one one is on this table.

13
00:00:50,820 --> 00:00:51,040
‫Right.

14
00:00:51,420 --> 00:00:58,410
‫So Byleth or Béranger vertical partition on the other hand, is you splitting literally vertically from

15
00:00:58,410 --> 00:00:59,460
‫top to bottom.

16
00:00:59,910 --> 00:01:08,460
‫And what do you do is use the essentially split columns within is entire junk of Roar's into a complete

17
00:01:08,460 --> 00:01:09,360
‫different partition.

18
00:01:09,810 --> 00:01:16,350
‫This is useful for like let's say you have a large column that is a blob and you bearly query that blob

19
00:01:16,350 --> 00:01:17,030
‫document.

20
00:01:17,040 --> 00:01:17,340
‫Right.

21
00:01:17,790 --> 00:01:24,570
‫You don't want that blob Torkham to take from your precious SSD space or the fast access.

22
00:01:24,570 --> 00:01:24,810
‫Right.

23
00:01:24,810 --> 00:01:25,520
‫That you have.

24
00:01:25,740 --> 00:01:31,620
‫So we're going to vertically partition it, put it in another table space, put it in its own table

25
00:01:31,620 --> 00:01:36,780
‫with its old documents, and then attach it to your master table.

26
00:01:36,780 --> 00:01:42,950
‫But if you query for that, the database knows or this particular column is at another table.

27
00:01:42,960 --> 00:01:45,970
‫So I have to jump in to that particular table to pull it.

28
00:01:46,260 --> 00:01:54,870
‫However, my beautiful fast access columns are and fast access and a proper table space in a and a proper

29
00:01:54,870 --> 00:01:55,800
‫SSD drive.

30
00:01:55,970 --> 00:01:57,360
‫And they are compact.

31
00:01:57,360 --> 00:01:58,490
‫They are not as large.

32
00:01:58,500 --> 00:02:02,340
‫So I just saved a lot of space in my desk.

33
00:02:02,430 --> 00:02:07,130
‫I just saved also a lot of access speed to the vertical.