1
00:00:00,060 --> 00:00:14,350
‫So now, if I do select Count Star from Grade's Original, where where where G is equal 30, right.

2
00:00:14,970 --> 00:00:18,690
‫How many rows we have around 10000 rows that are called 30.

3
00:00:19,110 --> 00:00:26,280
‫And then let's let's do this fancy thing as as go called explain analyze which which will explain how

4
00:00:26,280 --> 00:00:30,510
‫they came up with this result and it will tell you how long it took.

5
00:00:30,510 --> 00:00:37,140
‫So it took two seconds to exclude the square two thousand millisecond and it took like a point nine

6
00:00:37,140 --> 00:00:38,760
‫seven millisecond to plan it.

7
00:00:39,060 --> 00:00:41,310
‫And we use bitmap index Skåne.

8
00:00:42,180 --> 00:00:47,100
‫That means we picked we hadn't picked the values from the index and we went to the table.

9
00:00:47,520 --> 00:00:50,160
‫Sometimes this works, sometimes actually becomes a slope.

10
00:00:50,580 --> 00:00:52,260
‫And this is the number of rows that came back.

11
00:00:52,290 --> 00:01:02,200
‫So now if I do where g between 30 and let's say thirty five, that's a kind of different query, right.

12
00:01:02,250 --> 00:01:03,540
‫It's a range query.

13
00:01:03,810 --> 00:01:05,820
‫So it's going to be a little bit slower.

14
00:01:05,820 --> 00:01:11,040
‫And as we see it's like it took three seconds to execute and still the database decides to do with parallel

15
00:01:11,040 --> 00:01:11,480
‫index.

16
00:01:11,580 --> 00:01:16,210
‫And this time and then jumped back to the index and calculated the values.

17
00:01:16,500 --> 00:01:18,610
‫So that's that's what we see here, guys.