search

hyrise / index_selection_evaluation

Platform to evaluate index selection algorithms
MIT License
82 stars 27 forks source link

Change indexable columns and possible index methods #3

Closed Bensk1 closed 4 years ago

Bensk1 commented 4 years ago

We currently consider ALL columns in a query. However, it should be sufficient to consider columns that are part of the where clause, right? Thereby, we can reduce the number of evaluated possible indexes.

marcelja commented 4 years ago

select max(col1) from table should benefit from an index. Group by and order by as well. I think that we need some kind of simple sql parsing to find relevant columns.