Skip to content

Put the result of skip index analysis into query condition cache #85779

@CurtizJ

Description

@CurtizJ

Company or project name

ClickHouse Inc.

Use case

Speedup analysis of skip indexes.

Describe the solution you'd like

Put the result of skip index analysis into the query condition cache.

Now, the query condition cache is filled in the query runtime during the PREWHERE and WHERE stages. Therefore, ranges filtered by skip indexes won't get into the cache, and index analysis will be done each time. However, it's faster to save the analysis result into the query condition cache and filter ranges using it.

Additional context

It may also make sense for the primary index, but its analysis is usually lighter.
It is better to implement this task after #81526.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions