‫Beautiful.
‫So that's that's partitioning.
‫So let's discuss vertical versus horizontal partition, horizontal partition is splitting that the partition
‫biros, as we discussed in this case, where customers from this rows to this to this idea, to this
‫idea as and this partition and other customers from this idea to this idea, is this what we are splitting
‫biros like almost like horizontally?
‫Imagine this is like a knife, right?
‫It's like slicing in the middle, despising the table in the middle and then breaking the partitions
‫into multiple ones.
‫So that's that's the partition.
‫And there is like types of partition, like by rangers' like we did or less zipcode or nine or two or
‫five is on this table or partition zipcode nine one one one one is on this table.
‫Right.
‫So Byleth or Béranger vertical partition on the other hand, is you splitting literally vertically from
‫top to bottom.
‫And what do you do is use the essentially split columns within is entire junk of Roar's into a complete
‫different partition.
‫This is useful for like let's say you have a large column that is a blob and you bearly query that blob
‫document.
‫Right.
‫You don't want that blob Torkham to take from your precious SSD space or the fast access.
‫Right.
‫That you have.
‫So we're going to vertically partition it, put it in another table space, put it in its own table
‫with its old documents, and then attach it to your master table.
‫But if you query for that, the database knows or this particular column is at another table.
‫So I have to jump in to that particular table to pull it.
‫However, my beautiful fast access columns are and fast access and a proper table space in a and a proper
‫SSD drive.
‫And they are compact.
‫They are not as large.
‫So I just saved a lot of space in my desk.
‫I just saved also a lot of access speed to the vertical.