‫So although we do partitioning to do partitioning, guys, we're going to create the main table, which
‫is called table grades parts.
‫Right.
‫And here's the track, guys.
‫It's the same thing.
‫Serial not know.
‫And then that that great integer not no.
‫Also, but you have to say partition by range and which is the range in this case, the G will be the
‫range tier.
‫Right.
‫We didn't define the range, but you have to create a stable with partition in mind.
‫And just like that we created it.
‫Now you're responsible to create all the ranges, all the partition yourself, that the database is
‫not going to do this for you.
‫So I'm going to create the partition one by one now and I'm going to divide the partition as G, which
‫is just like and then the name of the table and then zero thirty five.
‫So grades from zero to thirty five goes into this table.
‫How do either of them create table Giurgiu.
‫And I'm going to make this exactly like the table above that.
‫Right.
‫So that I like the grades parts table and I'm going to include indexes.
‫I don't have to do that because there are no indexes in this table.
‫Remember, what I'm going to do is that going to add indexes after the fact?
‫And that's OK.
‫So now we have G zero thirty five.
‫That's just a normal table for now.
‫I just want to copy the same exact structure.
‫So if I describe this table, we have IDAG and there is no indexes or anything, so let's go ahead and
‫create the rest of the tables.
‫Did it from thirty five to sixty let's say, and then we're going to create.
‫From 60 to 80 and then finally from 80 to 100.
‫These are the four politicians in this case, only four politicians, and now what I'm going to do,
‫I am going to attach the partitions on my main main one by one to my major table.
‫And to do that, I do altar table which table?
‫Of course, the great parts that the partition table.
‫Right.
‫Attach partition zero zero thirty five, which is that stable for values.
‫Which values are this allowed for the stable, for values from zero to thirty five.
‫That's what I'm supposed to do.
‫Right.
‫And I have to do the same thing for the rest of the partitions, which is from thirty five to thirty
‫to sixty.
‫Right.
‫And we're going to change this guy to thirty five to sixty.
‫Boom.
‫And then we're going to do the same thing from 60 to 80.
‫Ed.
‫60 to 80, boom, and then finally, one hundred sixty eighty two hundred
‫eighty, two hundred nice.
‫Now these are or that but no dice.
‫This table is empty, it doesn't have anything.
‫It's empty.
‫So now if I if I describe any of the tables, obviously hundred they still they say the partition of
‫grades, parts for values from eighty.
‫It will describe details of this, but there are no indexes in this table nor on the the grid as clear
‫this upgrade parts.
‫There are no index here.