ClickHouse / ClickHouse/ClickHouse
Minmax data skipping index impact on min and max functions
Open
comp-skip-index
external
feature
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
It seems like the minmax index should affect min() and max() functions perfomance of the select queries without grouping if a server compares only min/max values of granule groups.
Sql example:
```Sql
create table measurements (
...
timestamp UInt64,
index idx_timestamp timestamp type minmax
)
...
```
```Sql
select max(timestamp) from measurements
```
It now executes full column scan (server version 23.3.8.21).
Contributor guide
Assessment
This issue has not been assessed yet.