‫So now, if I do select Count Star from Grade's Original, where where where G is equal 30, right.
‫How many rows we have around 10000 rows that are called 30.
‫And then let's let's do this fancy thing as as go called explain analyze which which will explain how
‫they came up with this result and it will tell you how long it took.
‫So it took two seconds to exclude the square two thousand millisecond and it took like a point nine
‫seven millisecond to plan it.
‫And we use bitmap index Skåne.
‫That means we picked we hadn't picked the values from the index and we went to the table.
‫Sometimes this works, sometimes actually becomes a slope.
‫And this is the number of rows that came back.
‫So now if I do where g between 30 and let's say thirty five, that's a kind of different query, right.
‫It's a range query.
‫So it's going to be a little bit slower.
‫And as we see it's like it took three seconds to execute and still the database decides to do with parallel
‫index.
‫And this time and then jumped back to the index and calculated the values.
‫So that's that's what we see here, guys.