‫A.B., the first I get I might be wrong that OK, it's not the first time actually said it's a transactional
‫database storage engine.
‫OK, so Orien, my my assim was not transaction, so I can do transactions on those things.
‫So I need something on transactions.
‫What could that be?
‫A.B., A.B., A.B..
‫Is that B plus three a little bit different than B three but essentially still balanced.
‫Right.
‫The same idea.
‫But he is a different A.B. versus my assim.
‫OK, the index is right.
‫There's always a primary key in A.B. versus my asking you.
‫You don't have to have a primary.
‫That's that's the thing.
‫Myozyme, everything is just an index.
‫Right.
‫And primary key in my ASM happens to be unique index.
‫And A.B., other than.
‫You have to have a primary, that's the first thing if you don't create a bramnick and you will create
‫one for you as a sequential.
‫Well, that's the first thing.
‫The primary key itself has well-defined primary key points to the role itself, as we discussed.
‫So I'm pointing directly to the two.
‫Right.
‫And any index you create, guess what?
‫It doesn't point directly to the arrow.
‫It points to the primary key.
‫That's powerful stuff right there, guys.
‫Right.
‫So if you it's it's like a primary, they'll go one to one.
‫Right.
‫That's powerful.
‫Right.
‫So if you if you create an index, that index, the secondary index doesn't point directly to the road
‫as an overall offset.
‫700 doesn't say that and say, oh, 700.
‫Oh, this index is actually pointing to that primarily and the primary key points to the road.
‫So you can immediately see there is multiple jumps and round trips to get to the road.
‫Right.
‫But that could be also beneficial if you're only selecting your primary key and your secondary key.
‫So you guys, a software engineer, database engine, you really need to understand these things.
‫When you're querying your Dabi, you don't do a select start.
‫That's the worst thing you ever do in a database.
‫If you do select star, you're hurting the day because you just it's it's like it has a life man and
‫you have to appreciate it and you have to just man this thing really, really understand how how you
‫deal with things and software.
‫It's very delicate.
‫OK, you're dishonoring the database by doing so.
‫Let's start guys, believe me.
‫And if you don't wear clothes, you better know what you're wearing on too many indexes are too bad.
‫Too little indexes are too bad.
‫Know your stuff.
‫Right.
‫And we can talk more about this.
‫I can make a whole video just about anybody.
‫Right.
‫I still don't understand so many things.
‫Right.
‫But every time I understand a little bit thing feel really good.
‫I, I appreciate the people who build these things more and more every day.
‫So I replaces my -- sometimes.
‫All right.
‫You don't need this stuff anymore, my --.
‫Right.
‫A lot of people I I do not agree with that statement, right, I hold oil and a lot of people say now,
‫don't use my animals, use energy, I need a raise.
‫I don't like people saying just blanket statement like that.
‫You have to have a good reason.
‫Right.
‫You have to have thought you have to think about every statement.
‫You say you can just replace it.
‫Well, there are features in my assim that A.B. is bad at the game.
‫So you get to think about that stuff sometimes.
‫It really depends on the use case.
‫Sometimes you use case could be a myosin, as we said.
‫Right.
‫I'm I don't know.
‫I'm reading a lot, but I'm barely updating my statement.
‫My my table's right.
‫I don't need transactions.
‫Right.
‫So think about that or I don't say this.
‫This is all technology.
‫No one uses it.
‫It's like it's like saying was like, oh, nobody uses Kerberos authentication or just throw it off
‫the window.
‫People built this thing in the 80s.
‫Yes, but those people are not dumb, OK?
‫There's always a reason guys think about it.
‫The default for my school and marry.
‫OK, so this becomes become the default.
‫Now, anybody that doesn't mean it's that the good choice.
‫Guys, think about it.
‫Right.
‫So default for my Sequenom already be.
‫And personally, I believe I might be wrong there.
‫I compliant transaction support, support all this good stuff aside.
‫Right I tomasetti consistency, isolation and the ability to pull foreign keys.
‫You know those guys, you know the foreign keys, whatever on keys.
‫Yeah.
‫I can create a foreign key that links to that and they, they can integrate together.
‫Some people have those Francie's.
‫I personally don't like to use the I just if I know why tables, I don't like to use this low level
‫function if I, if I can handle myself on the application again.
‫Right.
‫That's my opinion.
‫They will space's support.
‫That's consent to a table space.
‫Right.
‫This is again Oracle have this concept.
‫I believe Bosco's have this concept.
‫MySQL has been this concept of, hey, these tables are in this space.
‫You're arranging your storage for some reason.
‫I don't know the driver Cedro rather than bad idea, but you're wrong level locking.
‫OK, we're all level looking, that's a very good feature, I want to prevent people from editing that
‫law, that law.
‫Yeah, no amendments, guys, or is a word I want to prevent people from editing the roll.
‫Right.
‫And because I'm doing something to it, like I'm doing, like, I don't know what to serialize some
‫functionality.
‫Right.
‫So it's like if you're editing that, if your function or application trying to update that you by the
‫way, son, you cannot update the on unless I'm done.
‫I'm going to left my exclusive log and then you can do your stuff.
‫So that's powerful my --.
‫I'm only supports my assim only supports table level locking in a special operation which my assim doesn't
‫support.
‫I might be wrong there.
‫I think that that have been added.
‫But there is the problem.
‫It's owned by Oracle.
‫So guess what, what more did Morty created.
‫Extra TV, which is a Falkoff A. A.V..