1
00:00:00,120 --> 00:00:07,530
‫A.B., the first I get I might be wrong that OK, it's not the first time actually said it's a transactional

2
00:00:07,530 --> 00:00:08,890
‫database storage engine.

3
00:00:09,240 --> 00:00:15,720
‫OK, so Orien, my my assim was not transaction, so I can do transactions on those things.

4
00:00:15,720 --> 00:00:17,390
‫So I need something on transactions.

5
00:00:17,400 --> 00:00:18,640
‫What could that be?

6
00:00:18,900 --> 00:00:21,590
‫A.B., A.B., A.B..

7
00:00:22,890 --> 00:00:28,620
‫Is that B plus three a little bit different than B three but essentially still balanced.

8
00:00:28,620 --> 00:00:28,880
‫Right.

9
00:00:28,890 --> 00:00:29,630
‫The same idea.

10
00:00:30,060 --> 00:00:33,690
‫But he is a different A.B. versus my assim.

11
00:00:34,360 --> 00:00:37,440
‫OK, the index is right.

12
00:00:37,590 --> 00:00:42,420
‫There's always a primary key in A.B. versus my asking you.

13
00:00:42,930 --> 00:00:44,550
‫You don't have to have a primary.

14
00:00:45,060 --> 00:00:45,960
‫That's that's the thing.

15
00:00:46,200 --> 00:00:48,090
‫Myozyme, everything is just an index.

16
00:00:48,130 --> 00:00:48,320
‫Right.

17
00:00:48,480 --> 00:00:52,410
‫And primary key in my ASM happens to be unique index.

18
00:00:52,650 --> 00:00:54,840
‫And A.B., other than.

19
00:00:56,690 --> 00:01:01,400
‫You have to have a primary, that's the first thing if you don't create a bramnick and you will create

20
00:01:01,400 --> 00:01:02,990
‫one for you as a sequential.

21
00:01:03,170 --> 00:01:04,460
‫Well, that's the first thing.

22
00:01:04,580 --> 00:01:11,540
‫The primary key itself has well-defined primary key points to the role itself, as we discussed.

23
00:01:11,780 --> 00:01:13,860
‫So I'm pointing directly to the two.

24
00:01:14,540 --> 00:01:14,870
‫Right.

25
00:01:15,230 --> 00:01:18,310
‫And any index you create, guess what?

26
00:01:18,890 --> 00:01:20,870
‫It doesn't point directly to the arrow.

27
00:01:21,380 --> 00:01:23,500
‫It points to the primary key.

28
00:01:24,200 --> 00:01:26,440
‫That's powerful stuff right there, guys.

29
00:01:26,510 --> 00:01:26,880
‫Right.

30
00:01:27,440 --> 00:01:30,950
‫So if you it's it's like a primary, they'll go one to one.

31
00:01:30,950 --> 00:01:31,120
‫Right.

32
00:01:31,130 --> 00:01:31,910
‫That's powerful.

33
00:01:31,910 --> 00:01:32,120
‫Right.

34
00:01:32,300 --> 00:01:37,970
‫So if you if you create an index, that index, the secondary index doesn't point directly to the road

35
00:01:37,970 --> 00:01:39,500
‫as an overall offset.

36
00:01:39,500 --> 00:01:42,860
‫700 doesn't say that and say, oh, 700.

37
00:01:43,340 --> 00:01:48,580
‫Oh, this index is actually pointing to that primarily and the primary key points to the road.

38
00:01:48,890 --> 00:01:53,970
‫So you can immediately see there is multiple jumps and round trips to get to the road.

39
00:01:54,190 --> 00:01:54,490
‫Right.

40
00:01:54,680 --> 00:02:01,280
‫But that could be also beneficial if you're only selecting your primary key and your secondary key.

41
00:02:01,280 --> 00:02:06,560
‫So you guys, a software engineer, database engine, you really need to understand these things.

42
00:02:06,830 --> 00:02:09,860
‫When you're querying your Dabi, you don't do a select start.

43
00:02:09,860 --> 00:02:13,340
‫That's the worst thing you ever do in a database.

44
00:02:14,390 --> 00:02:21,500
‫If you do select star, you're hurting the day because you just it's it's like it has a life man and

45
00:02:21,500 --> 00:02:28,970
‫you have to appreciate it and you have to just man this thing really, really understand how how you

46
00:02:28,970 --> 00:02:31,650
‫deal with things and software.

47
00:02:31,970 --> 00:02:33,220
‫It's very delicate.

48
00:02:33,470 --> 00:02:37,340
‫OK, you're dishonoring the database by doing so.

49
00:02:37,340 --> 00:02:39,500
‫Let's start guys, believe me.

50
00:02:40,210 --> 00:02:46,160
‫And if you don't wear clothes, you better know what you're wearing on too many indexes are too bad.

51
00:02:46,160 --> 00:02:47,870
‫Too little indexes are too bad.

52
00:02:48,290 --> 00:02:49,460
‫Know your stuff.

53
00:02:49,460 --> 00:02:49,790
‫Right.

54
00:02:49,790 --> 00:02:51,290
‫And we can talk more about this.

55
00:02:51,300 --> 00:02:54,140
‫I can make a whole video just about anybody.

56
00:02:54,320 --> 00:02:54,570
‫Right.

57
00:02:54,860 --> 00:02:57,890
‫I still don't understand so many things.

58
00:02:57,890 --> 00:02:58,160
‫Right.

59
00:02:58,340 --> 00:03:02,120
‫But every time I understand a little bit thing feel really good.

60
00:03:02,120 --> 00:03:08,270
‫I, I appreciate the people who build these things more and more every day.

61
00:03:08,570 --> 00:03:09,860
‫So I replaces my -- sometimes.

62
00:03:10,530 --> 00:03:10,970
‫All right.

63
00:03:11,210 --> 00:03:12,800
‫You don't need this stuff anymore, my --.

64
00:03:12,950 --> 00:03:13,250
‫Right.

65
00:03:14,710 --> 00:03:24,220
‫A lot of people I I do not agree with that statement, right, I hold oil and a lot of people say now,

66
00:03:24,370 --> 00:03:28,880
‫don't use my animals, use energy, I need a raise.

67
00:03:28,900 --> 00:03:32,350
‫I don't like people saying just blanket statement like that.

68
00:03:32,350 --> 00:03:35,470
‫You have to have a good reason.

69
00:03:35,470 --> 00:03:35,770
‫Right.

70
00:03:35,770 --> 00:03:39,070
‫You have to have thought you have to think about every statement.

71
00:03:39,070 --> 00:03:41,660
‫You say you can just replace it.

72
00:03:41,820 --> 00:03:45,210
‫Well, there are features in my assim that A.B. is bad at the game.

73
00:03:45,730 --> 00:03:49,600
‫So you get to think about that stuff sometimes.

74
00:03:49,900 --> 00:03:52,120
‫It really depends on the use case.

75
00:03:52,120 --> 00:03:55,060
‫Sometimes you use case could be a myosin, as we said.

76
00:03:55,060 --> 00:03:55,360
‫Right.

77
00:03:55,500 --> 00:03:57,160
‫I'm I don't know.

78
00:03:57,190 --> 00:04:00,550
‫I'm reading a lot, but I'm barely updating my statement.

79
00:04:00,550 --> 00:04:02,410
‫My my table's right.

80
00:04:02,440 --> 00:04:03,760
‫I don't need transactions.

81
00:04:04,450 --> 00:04:04,740
‫Right.

82
00:04:04,840 --> 00:04:06,910
‫So think about that or I don't say this.

83
00:04:07,360 --> 00:04:08,500
‫This is all technology.

84
00:04:08,680 --> 00:04:09,610
‫No one uses it.

85
00:04:11,320 --> 00:04:16,870
‫It's like it's like saying was like, oh, nobody uses Kerberos authentication or just throw it off

86
00:04:16,870 --> 00:04:17,410
‫the window.

87
00:04:17,710 --> 00:04:20,060
‫People built this thing in the 80s.

88
00:04:20,080 --> 00:04:23,480
‫Yes, but those people are not dumb, OK?

89
00:04:23,860 --> 00:04:26,340
‫There's always a reason guys think about it.

90
00:04:26,680 --> 00:04:29,260
‫The default for my school and marry.

91
00:04:29,980 --> 00:04:32,020
‫OK, so this becomes become the default.

92
00:04:32,020 --> 00:04:36,610
‫Now, anybody that doesn't mean it's that the good choice.

93
00:04:36,790 --> 00:04:38,110
‫Guys, think about it.

94
00:04:38,110 --> 00:04:38,470
‫Right.

95
00:04:38,980 --> 00:04:40,630
‫So default for my Sequenom already be.

96
00:04:40,630 --> 00:04:43,240
‫And personally, I believe I might be wrong there.

97
00:04:44,650 --> 00:04:50,330
‫I compliant transaction support, support all this good stuff aside.

98
00:04:50,560 --> 00:04:55,600
‫Right I tomasetti consistency, isolation and the ability to pull foreign keys.

99
00:04:55,930 --> 00:04:58,860
‫You know those guys, you know the foreign keys, whatever on keys.

100
00:04:58,870 --> 00:04:59,220
‫Yeah.

101
00:04:59,260 --> 00:05:03,790
‫I can create a foreign key that links to that and they, they can integrate together.

102
00:05:04,390 --> 00:05:06,010
‫Some people have those Francie's.

103
00:05:06,250 --> 00:05:13,000
‫I personally don't like to use the I just if I know why tables, I don't like to use this low level

104
00:05:13,000 --> 00:05:18,000
‫function if I, if I can handle myself on the application again.

105
00:05:18,340 --> 00:05:18,610
‫Right.

106
00:05:18,670 --> 00:05:19,570
‫That's my opinion.

107
00:05:20,020 --> 00:05:21,160
‫They will space's support.

108
00:05:21,160 --> 00:05:23,950
‫That's consent to a table space.

109
00:05:23,950 --> 00:05:24,190
‫Right.

110
00:05:24,220 --> 00:05:26,830
‫This is again Oracle have this concept.

111
00:05:26,830 --> 00:05:28,660
‫I believe Bosco's have this concept.

112
00:05:29,110 --> 00:05:32,650
‫MySQL has been this concept of, hey, these tables are in this space.

113
00:05:33,190 --> 00:05:35,740
‫You're arranging your storage for some reason.

114
00:05:35,740 --> 00:05:41,530
‫I don't know the driver Cedro rather than bad idea, but you're wrong level locking.

115
00:05:42,450 --> 00:05:48,780
‫OK, we're all level looking, that's a very good feature, I want to prevent people from editing that

116
00:05:48,780 --> 00:05:50,380
‫law, that law.

117
00:05:50,710 --> 00:05:58,400
‫Yeah, no amendments, guys, or is a word I want to prevent people from editing the roll.

118
00:05:58,500 --> 00:05:58,930
‫Right.

119
00:05:59,340 --> 00:06:05,610
‫And because I'm doing something to it, like I'm doing, like, I don't know what to serialize some

120
00:06:05,610 --> 00:06:06,330
‫functionality.

121
00:06:06,330 --> 00:06:06,630
‫Right.

122
00:06:06,660 --> 00:06:12,600
‫So it's like if you're editing that, if your function or application trying to update that you by the

123
00:06:12,600 --> 00:06:16,380
‫way, son, you cannot update the on unless I'm done.

124
00:06:16,470 --> 00:06:20,240
‫I'm going to left my exclusive log and then you can do your stuff.

125
00:06:20,550 --> 00:06:22,530
‫So that's powerful my --.

126
00:06:22,560 --> 00:06:30,270
‫I'm only supports my assim only supports table level locking in a special operation which my assim doesn't

127
00:06:30,270 --> 00:06:30,710
‫support.

128
00:06:31,200 --> 00:06:32,190
‫I might be wrong there.

129
00:06:32,190 --> 00:06:34,710
‫I think that that have been added.

130
00:06:35,040 --> 00:06:37,020
‫But there is the problem.

131
00:06:37,020 --> 00:06:38,370
‫It's owned by Oracle.

132
00:06:38,790 --> 00:06:42,350
‫So guess what, what more did Morty created.

133
00:06:42,360 --> 00:06:44,970
‫Extra TV, which is a Falkoff A. A.V..